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
- 24106 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 nvl in db2?
What is cursor in dbms?
How to create backup table in db2?
Explain db2.
Explain the benefits you can get from mainframe connect?
What is page size in db2?
What are catalog tables in db2?
What is phantom read in db2?
What is null value in db2?
Explain what are the various isolation levels possible?
What is the latest version of ibm db2?
What is syscat in db2?
What is explain in db2?
What is the role of the data page in the db2 database?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
