Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What is the difference between IN subselects and EXISTS

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

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

cursor with hold explain ?

1 Answers   Verizon,

Name some fields from SQLCA.

2 Answers  

what is different three logs in DB2?

1 Answers   Syntel,

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

How would the varchar column remarks defined?

0 Answers  

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,