select emp-id from emp group by emp-id having count(*)>1;

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the benefits you can get from mainframe connect?

1017

What is bufferpool in db2?

1098

What is cobol db2?

1049

What is the maximum number of columns in a db2 table?

1349

What is schema in db2?

1084

What is universal database?

1121

How can you classify the locks in db2?

1135

What is ibm db2 client?

1008

What is declare cursor?

1169

Explain about rct.

1132

What is dclgen in db2?

1201

What is cursor with hold option in db2?

1138

Name the various locking levels available?

1136

Explain about rct in db2?

1166

How do I copy a table in db2?

1058