What is the difference between IN subselects and EXISTS
subselect?
- 1 Answers
- 9888 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 |
How to access db2 tables in mainframe?
Define db2.
Why db2 is called db2?
Which catalog table stores referential constraints?
how to unload different table data into different gdg files/ vsam files.
What are union and union all?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What is UNION,UNION ALL?
How can the duplicate values be eliminated from db2 select?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What is auditing?
What is the physical storage length of the data types date, time, and timestamp?
COBOL 
