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 physical storage length of the data types: date, time, timestamp in the db2 database?

648

How and when does the db2 enforces the unique key?

613

Explain packages.

662

Is db2 a mainframe database?

567

what is the sqlcode -501

11299

Define declaration generator (dclgen).

665

What is an instance in db2?

563

How to check last update on table in db2?

627

What is the difference between dbm cfg and db cfg file in db2 ?

1004

What is database manager in db2?

549

What is a page in db2?

610

What are concurrency issues?

628

Which isolation level provides highest data integrity?

597

can we view the access paths created by dbrm ? how ? thx

6245

What is plan in cobol db2?

589