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 db2 400?

677


How does db2 sample database connect?

568


What is check constraint in db2?

608


What is cascading rollback?

623


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1595






What is copy pending and check pending in db2?

578


How do I delete a table in database?

599


What is query_cache_limit?

543


What is multi row fetch in db2?

603


How to execute stored procedure in db2 command editor?

532


What is the role of schema in the db2 database?

649


What is a trigger in the db2 database?

592


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1712


How many types of page locks can be held in db2?

589


Before you give the explain statement, what are the prerogatives?

579