In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / venkat
select emp-id from emp group by emp-id having count(*)>1;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a Foreign Key?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is release/acquire in bind?
What is null value in db2?
How do I optimize a query in db2?
What is cobol db2?
What are db2 objects?
What is cascading rollback?
Why cursor is used in db2?
What is the max length of sqlca?
What is rebind in db2?
What is host variable in db2 cobol?
Explain about dbrm.
What is the maximum size of varchar data type in db2?
What is the result of open cursor statement?