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

What is image copy in db2?

943

What is reorg and runstats in db2?

1142

What is cloudant database?

1024

What is table space in db2?

959

What is db2?

1123

What is deadlock in db2?

1012

What is a db2 collection?

981

What is null indicator in cobol db2?

991

What are db2 objects?

999

Define buffer pool.

996

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1053

How do you stop a db2 database in linux?

956

What is buffer pool in the db2 database?

1046

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1134

What is db2 purescale?

940