In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 18807 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / manikandan.d
hi all i hope this answer will help you
emp
eid ename dep
001 manikandan mainframe
002 karthi java
003 jarin mainframe
001 manikandan java
003 jarin testing
004 hariharan java
001 manikandan testing
select eid from emp e1 where 1 <
(select count(*) from emp e2 where e1.eid=e2.eid)
let me know if any new answer
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is null in db2?
What is dpf in db2?
What is page size in db2?
What is the latest version of ibm db2?
Mention data types used in db2 ?
What is the use of predicate?
What is a collection in db2?
What is db2 connect?
What is bind and rebind in db2?
What is buffer pool?
How can you quickly find out the # of rows updated after an update statement?
What is the purpose of rollback and commit?
What are packages in db2?
What is db2 command?
How to take backup of table in db2?
