IN subselect will return rows that match the values in the IN list. EXIST

What is the difference between IN subselects and EXISTS
subselect?

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

How do I add a column in db2?

587

What is the role of the data page in the db2 database?

583

How to run db2 command in windows?

641

Which component is used to execute the sql statements?

617

Is it possible to create an Instance in DB2 using DB2 Control Center ?

622

What is the maximum size of varchar data type in db2?

643

What is a collection in db2?

579

How do I optimize a query in db2?

611

What is ibm db2 client?

516

What is the default page size of buffer pools?

644

What is image copy in db2?

564

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

702

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1572

Can we update view in db2?

555

What is an instance database?

598