select A.empid from EMP A, EMP B where A.empid = B.empid and A.dept not =

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

Question Posted / sri

Answer Posted / sri

select A.empid from EMP A, EMP B where
A.empid = B.empid and
A.dept not = B.dept

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a db2 collection?

605

Define predicate?

643

On which levels locks can be applied?

657

What is an instance database?

600

what is diffrence b/w file-aid tool and file-aid utility???

4178

Define declaration generator (dclgen).

665

What is bind in db2?

604

What is image copy in db2?

570

How do I import data from excel to db2?

615

What is nvl in db2?

625

What is the physical storage length of the data types date, time, and timestamp?

608

Is it possible using max on a char column?

607

What is load utility in db2?

668

What is a db2 table?

596

Why do we need reorg in db2?

564