What is the difference between IN subselects and EXISTS
subselect?
- 1 Answers
- 10371 Views
- HCL, PreVator, TCS, I also Faced
- E-Mail Answers
Answer Posted / s
IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
true value.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is dbrm?
What is concurrency?
How do I create a view in db2?
What is the picture clause of null indicator variable?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How do you eliminate duplicate values in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How do I copy a table in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is drop table?
Can you use max on a char column?
What is sqlca?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Is ibm db2 free?
What is database alias db2?
