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 are the various isolation levels possible?

1124

What is the physical storage length of date data type?

1259

What's The Error Code For Unique Index Voilation?

1244

Is db2 a programming language?

1055

What do you mean by storage group (stogroup)?

1044

How to find the number of rows in a db2 table?

1121

How do we specify index to include or not during bind process.

2132

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3158

How to restart a DB2 program?

1911

What is the difference between nvl and coalesce?

1067

Give the name of some fields form sqlca.

1091

What is the maximum size of a char data type in db2?

1013

How do I add a column to a table in db2?

1107

What are union and union all?

986

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2049