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 / anonymous

Answer Posted / anonymous

select emp_id from employee where dept in (select distinct
dept from employee) group by emp_id having count(*) >1;

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain the function of data manager.

1052

Which are the db2 tools to protect integrity of the database?

1130

Can we delete records from view?

974

Explain about open switch business continuity software?

1141

How do I change the column size in db2?

1165

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

1114

What is ibm db2 used for?

1091

What is ibm db2 database?

1017

What is the use of with ur in db2?

1061

What kind of database is db2?

1042

What is an instance in db2?

1044

Where do you specify them?

1292

Why cursor is used in db2?

1041

Can you use max on a char column?

1102

What is the default page size of buffer pools?

1128