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

what is a corelated subquerry?

1062

what is the role of the cursor in db2?

999

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1134

How and when does the db2 enforces the unique key?

1028

What is a collection in db2?

978

How to resolve deadlock issue

19854

Mention the definition of cobol in varchar field.

1176

What os does db2 run on?

923

Explain in detail about buffer manager and its functionalities?

991

Explain dclgen.

1141

What parameters are used to control the free space in DB2?

1004

What is the difference between plan and package in db2?

1034

What is the purpose of rollback and commit?

1083

How would you find out the total number of rows in a db2 table?

986

what is utility for parm lib

2306