select employee-id from table-name grtoup by employee-id having coun

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

Question Posted / krishnakumar

Answer Posted / krishnakumar

select employee-id
from table-name
grtoup by employee-id
having count(*) > 1

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the use of runstats in db2?

1184

What is buffer pool and list some of them?

1098

What is netezza database?

1082

Explain about open switch business continuity software?

1188

What is the use of predicate?

1089

What is the role of the data page in the db2 database?

1085

How to retrieve rows from a db2 table in embedded sql?

1448

What is null indicator in cobol db2?

1113

What is rebind in db2?

1119

what is utility for parm lib

2423

Define predicate?

1204

If I have a view which is a join of two or more tables, can this view be updateable?

1187

Differentiate between cs and rr isolation levels? Where do you specify them?

1122

What language is db2 written in?

1107

What is runstats and reorg in db2?

1363