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
- 23497 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
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is load replace in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What's The Error Code For Unique Index Voilation?
What is database alias db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is release/acquire in bind?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
define clustering index.
How does cobol compile db2 program?
How do you select a row using indexes in db2?
How do I import data from excel to db2?
Explain about rct.
What is the physical storage length of timestamp data type?
i want to maintain uniqueness on pdf without make lf??????????
