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

Answer Posted / krishnakumar

Ans 5 is also correct but it seems a bit compliceted

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is utility for parm lib

1964


what is the sqlcode -501

11603


How do you simulate the explain of an embedded sql statement in spufi/qmf?

696


Describe major components of db2?

713


What is dbrm? What it contains? When it will be created?

654






When do you specify the isolation level?

669


Can you tell me how can you find out the # of rows updated after an update statement?

686


What is precompiler in db2?

648


How do I add a column in db2?

653


What is the role of schema in the db2 database?

727


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

817


What is a buffer in memory?

666


How does coalesce work?

648


Are views updateable?

710


How to get the ddl of a table in db2?

736