Interested to Buy Any Domain ? << Click Here >> for more details...
In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 24191 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
Which command is used to remove all rows from a table?
What is schema in db2?
What is iseries database?
What is clone table?
Is ibm db2 free?
What is image copy in db2?
What is the meaning concurrency in the db2 database?
What is the connection string to connect to the DB2 Database ?
Highlight all the advantages that are attached to a package.
What is precompiler in db2?
What is database reorganization?
List out the buffer pools in db2
What is database alias db2?
What is the use of dclgen in db2?
What are db2 objects?
