select dept,empid , count(*) from table goup by dept,empid having count

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

Question Posted / karthik

Answer Posted / karthik

select dept,empid , count(*)
from table
goup by dept,empid
having count(*) > 1

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do I start db2 in windows?

1104

How will you return the number of records in table?

940

How connect db2 database to datastage?

1247

Which is faster delete or truncate?

1131

How do I delete a table in database?

1027

What is alias in db2?

1066

What is a dbrm in db2?

1029

When the like statement is used?

1226

What are db2 tables?

1130

What is the picture clause of null indicator variable?

1138

What is db2 command?

1042

How do you eliminate duplicate values in db2?

1198

How many databases can be created inside an instance in db2 ?

1038

What is a db2 table?

1022

What's The Error Code For Unique Index Voilation?

1242