In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 18857 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vish
Another classic example of people replying to the queries
in hurry..the answer #1, #2, #3, #4 & #7 are WRONG ANSWERS.
Answer #6 is correct. Answer #5 also seems to be correct to
me (unfortunatley I can't run & verify it at the moment,
someone please verify it & let everyone know).
Ram.g, FYI..EXISTS clause just denotes whether query after
EXISTS clause returned any row or not, it NEVER give a
count of the number of rows returned. Here need to find if
there are more than one rows (i.e count is needed) so
EXISTS can't be used here.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are packages in db2?
What is precompiler in db2?
How to check sequence on a table in db2?
Explain how can you do the explain of a dynamic sql statement?
i want to maintain uniqueness on pdf without make lf??????????
What is concurrency?
Define buffer pool.
What is the function of logging in the db2 database?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How do I start db2 in windows?
what is db2 restart?
What is temporal table in db2?
Which command is used to remove all rows from a table?
How does coalesce work?
What is the difference between dbm cfg and db cfg file in db2 ?
