Select emp_id from employee group by emp_id,dept having count(*)>1;

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

Question Posted / varun

15 Answers
23518 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / varun

Select emp_id
from
employee
group by emp_id,dept
having count(*)>1;

Is This Answer Correct ?

26 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1103

What are the various data types available in db2?

1015

How do I start db2 in windows?

1024

Explain about rct in db2?

1046

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1034

What is host variable?

1016

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2869

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1033

What is the default page size of buffer pools?

1073

What is db2 stogroup?

1096

Define buffer pool.

999

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2024

What is difference between rollback and commit?

1095

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1221

What is check constraint in db2?

1014