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 the maximum No of rows per page?

1072

What is a db2 table?

1022

What is db2 bind process?

1244

Explain about rct in db2?

1112

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2219

What are catalog tables in db2?

1052

Which component is used to execute the sql statements?

1102

What is meant by union and union all?

1012

Define data page.

1074

How do I add a column to an existing table in db2?

1032

Why do chiropractors use drop table?

1112

Why do we bind in db2?

1216

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1187

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1109

What's The Percentage Free Space ?

1227