In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / anonymous
select emp_id from employee where dept in (select distinct
dept from employee) group by emp_id having count(*) >1;
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do you find the maximum value in a column in db2?
What does db2 plan contain?
What is a plan and package in db2?
What does runstats do in db2?
What parameters are used to control the free space in DB2?
What does db2 mean?
Explain about rct in db2?
How to compare data between two tables in db2?
What is the syntax for creating a table in the db2 database?
What is runstats db2?
what is a corelated subquerry?
What is the use of db2?
What is buffer pool?
is it compulsory commitment control in journal?
What are catalog tables in db2?