Select emp_id from employee where dept IN (select DISTINCT dept from empl

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

Question Posted / ab

Answer Posted / ab

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

Is This Answer Correct ?

2 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How to check table size in db2 sap?

1100

Which component is used to execute the sql statements?

1149

Why do we need reorg in db2?

1047

How can you do the explain of a dynamic sql statement?

1112

What is meant by explain?

1198

What is a bind in db2?

1110

How to find the number of rows in db2 tables?

1133

Which is faster delete or truncate?

1179

Are view updateable?

1095

What is commit in db2?

1110

What is the difference between dbm cfg and db cfg file in db2 ?

1595

What is the advantage in De-normalizing tables in DB2?

1238

What is clone table?

1114

Why select is not preferred in embedded sql programs?

1355

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1154