Select emp_id from employee where dept IN (select all dept from emp

In a single table,How to retrieve a employee-id of an
employee who works in more than one department?

Question Posted / prasenjit_in

Answer Posted / prasenjit_in

Select emp_id from employee where dept IN (select all
dept from employee);

Is This Answer Correct ?

4 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What action db2 takes when a program aborts in the middle of a transaction?

1093

What is db2 connect?

1013

What's The Error Code For Unique Index Voilation?

1155

What is the use of with ur in db2?

1005

What are catalog tables in db2?

985

What is dclgen in db2?

1087

What are types of indexes?

1002

What is image copy in db2?

946

How do I change the column size in db2?

1086

What is the information associated with sysibm.syslinks table?

1059

is it compulsory commitment control in journal?

2423

What is consistency token in db2?

1068

What is db2 stogroup?

1100

List down the types of triggers in the db2 database?

965

What are the various data types available in db2?

1016