Interested to Buy Any Domain ? << Click Here >> for more details...
In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 24138 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
Can you use max on a char column?
What is clone table?
What type of database is db2?
What is the physical storage length of timestamp data type?
What is a system catalog table in db2?
What is db2?
What is performance tuning db2?
What is cloudant database?
What are union and union all?
what is utility for parm lib
What is commit in db2?
What is host variable?
How to find primary key of a table in db2?
What is innodb buffer pool?
What is query_cache_limit?
