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
What is consistency token in db2?
How do I connect my db2 database to ibm?
Explain about rct in db2?
Is schema the same as database?
What are concurrency issues?
What is the reason behind not using select * in embedded sql programs?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What are the various isolation levels possible?
What are the full forms of spufi and dclgen and why are they used?
What is drop table?
What is release/acquire in bind?
What is universal database?
What is cursor with hold option in db2?
What types of tables are there in the db2 database?
What is the picture clause of null indicator variable?