SELECT EMPLOYEE-ID FROM EMPLOYEE GROUP BY EMPLOYEE-ID,DEPARTMENT HAVING COU

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

Question Posted / venkat

Answer Posted / venkat

SELECT EMPLOYEE-ID FROM EMPLOYEE GROUP BY EMPLOYEE-ID,DEPARTMENT HAVING COUNT( DEPARTMENT ) > 1;

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

B37 abend during spufi?

1406

What is ibm db2 client?

883

What is a trigger in the db2 database?

1015

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1183

What is the difference between spufi and qmf?

1054

What is the physical storage length of date data type?

1191

Which command is used to connect to a database in DB2 ? Give the Syntax.

1033

What is null in db2?

950

What are catalog tables in db2?

983

What is image copy in db2?

946

What does db2 stand for?

961

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

1221

What is runstats utility in db2?

963

What are the 2 sqlcodes that are returned?

1131

What are foreign keys in db2?

1037