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
- 24551 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
Name the various locking levels available?
What is the difference between cursor and select statement?
How is a typical db2 batch pgm executed?
What are catalog tables in db2?
Explain about mirror activator disk mirroring?
What are db2 tables?
What is explain in db2?
How do I start db2 in windows?
How do you stop a db2 database in linux?
How is deadlock resolved?
Explain the function of data manager.
What are iseries servers?
Is db2 free?
What is host variable in db2 cobol?
Is the primary key a clustered index?
