Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN subselects and EXISTS
subselect?
- 1 Answers
- 11194 Views
- HCL, PreVator, TCS, I also Faced
- E-Mail Answers
Answer / 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 |
What is image copy in db2?
Define buffer pool.
What is the cascade rule and how does it relate to deletions made with a subselect?
what is differnece between DROP TABLE & DELETE TABLE .
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
what is utility for parm lib
What is the difference between dbm cfg and db cfg file in db2 ?
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 host variable in db2 cobol?
how can you access index
can all users have the privilage to use the sql statement select * (dml)?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
COBOL 
