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

How to access db2 tables in mainframe?

993

What are the various data types available in db2?

1015

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1045

What is db2 instance?

1019

What is the usage of open cursor command?

1040

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

1221

What is check constraint in db2?

1014

What do you mean by storage group (stogroup)?

985

What is host variable in db2 cobol?

1032

What is a db2 tablespace?

1002

Highlight all the advantages that are attached to a package.

1075

What is alias in db2?

983

What does sqlcabc has?

996

How does db2 sample database connect?

975

What is sqlca?

1001