What is the difference between IN subselects and EXISTS
subselect?



What is the difference between IN subselects and EXISTS subselect?..

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

Post New Answer

More DB2 Interview Questions

What is the difference between CS and RR isolation levels?

1 Answers  


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


What is a plan and package in db2?

0 Answers  


What are the three types of page locks that can be held?

1 Answers  


why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,






Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,


what is the use of cursors?

3 Answers   iGate,


which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,


What is meant by index cardinality?

2 Answers  


5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


What is ibm db2 used for?

0 Answers  


Categories