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
- 24114 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
Explain about open switch business continuity software?
Define data page.
what is diffrence b/w file-aid tool and file-aid utility???
Is it possible using max on a char column?
Explain packages.
What is ibm db2 used for?
What is access path in db2?
What is the maximum number of columns in a db2 table?
What is db2 connect?
Explain how can you do the explain of a dynamic sql statement?
How to check sequence on a table in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How can you find out the # of rows updated after an update statement?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
