In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 18853 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / millar
select employee_id,department_id from emp where employee_id in(select employee_id from emp where department_id in (select distinct
department_id from emp) group by employee_id,department_id having count(*) >1);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is db2 a mainframe database?
How to test SQL -911 error while developing COB-DB2 program
What is buffer pool in the db2 database?
What are host variables in db2?
What is db2 stogroup?
What is db2 instance?
What language is db2 written in?
What is image copy in db2?
Is ibm db2 free?
What is universal database?
What os does db2 run on?
How does db2 sample database connect?
How to create backup table in db2?
Where can you declare a cursor in a cobol-db2 program?
What is bind plan?
