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 is deadlock in db2?

1124

What is alias in db2?

1113

what is diffrence b/w file-aid tool and file-aid utility???

4968

What are db2 objects?

1093

Can there be more than one cursor open for any program?

1228

Is db2 a programming language?

1104

Why db2 is called db2?

1109

What is the syntax for FETCH in DB2 ?

1272

What is syscat in db2?

1072

How will you return the number of records in table?

997

What is the difference between cursor stability and repeatable read isolation levels?

1240

Explain packages.

1174

How do you pull up a query which was previously saved in qmf?

1206

What is scrollable cursor in db2?

1128

What is db2 and what is the use of db2 optimizer?

1116