In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / krishnakumar
select employee-id
from table-name
grtoup by employee-id
having count(*) > 1
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What parameters are used to control the free space in DB2?
How to access db2 tables in mainframe?
What is a plan and package in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is dclgen in db2?
What r the comman abends in db2, jcl and cobol???????
How do I connect my db2 database to ibm?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How can we retrieve the total number of records in RPG & CLLE?
What is ibm db2 connect?
Is it possible using max on a char column?
What are union and union all?
What are concurrency issues?