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
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is a system catalog table in db2?
Is ibm db2 free?
Why cursor is used in db2?
What is temporal table in db2?
What is data manager?
What is the reason behind not using select * in embedded sql programs?
How to find the maximum value in a column in the db2 database?
can we view the access paths created by dbrm ? how ? thx
How to check last update on table in db2?
Can one database have multiple instances?
Mention the downsides of page level lock.
Why db2 is called db2?
How to take backup of table in db2?
What is the physical storage length of the data types date, time, and timestamp?