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

What is temporal table in db2?

1102

Explain about rct.

1132

What is explain in db2?

1080

What are host variables in db2?

1125

What is dbrm library?

1118

What's The Percentage Free Space ?

1285

Can there be more than one cursor open for any program?

1227

What is view db2?

1133

How can you find out the # of rows updated after an update statement?

1155

What is db2 optimizer?

1316

What is database alias db2?

1182

What is drop table?

1071

What is the syntax for creating a table in the db2 database?

1150

List out the data types available.

1206

When do you specify the isolation level?

1073