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

Answer Posted / ram.g

ans 5 need to be corrected...

subquery will fetch correct result but main query hw it
will compare... ???

it supposed to be where eid exists(select eid...where
e1.eid= e2.eid)

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does db2 blu stand for?

764


Which components manage deadlocks in db2?

705


Can we update view in db2?

656


What is db2 bind process?

834


What does db2 stand for?

672






What is the use of dclgen in db2?

690


What is cursor in dbms?

705


How can we retrieve the total number of records in RPG & CLLE?

280


What are the contents of a dclmgen?

716


What is the use of reorg in db2?

702


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

719


What is null indicator in cobol db2?

681


B37 abend during spufi?

1090


What are db2 tables?

745


What are packages in db2?

689