In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 18798 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 is the difference between cursor and select statement?
What is cascading rollback?
How to check table size in db2 sap?
what is diffrence b/w file-aid tool and file-aid utility???
What is universal database?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How to find the maximum value in a column in the db2 database?
Explain about rct in db2?
What is the maximum number of columns in a db2 table?
Are views updateable?
What is the picture clause of null indicator variable?
On which levels locks can be applied?
What is performance tuning db2?
Is db2 a mainframe database?
What is explain in db2?
