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 the result of open cursor statement?

1085

What is universal database?

1074

What is table space in db2?

1025

What is cascading rollback?

1220

How do I add a column in db2?

1053

What is null indicator in cobol db2?

1070

Explain the contents that are a part of dclgen.

1094

Explain the contention situations caused by locks?

1076

What is sqlca’s maximum length?

1197

What is temporal table in db2?

1047

What do you mean by cursor?

994

What are the uses of db2 optimizer?

1299

How do I import a csv file into db2?

995

What is a page in db2?

1030

Explain how can you do the explain of a dynamic sql statement?

1130