What is the difference between IN subselects and EXISTS subselect?

What is the difference between IN subselects and EXISTS
subselect?

Question Posted / guest

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

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

More DB2 Interview Questions

What is a cursor and what is its function?

Highlight all the advantages that are attached to a package.

What's The Percentage Free Space ?

How can you compare table column after update and before update?

Differentiate between cs and rr isolation levels? Where do you specify them?

What is sqlca?

What is release/acquire in bind?

What are the various locking levels available?

how can we find nth max salary from A table

Mention data types used in db2 ?

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

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

For more DB2 Interview Questions Click Here