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


Difference between IN and EXISTS

Answers were Sorted based on User's Feedback



Difference between IN and EXISTS..

Answer / udaykumar

IN - returns a numeric value.
EXIT - returns a boolean value.

Is This Answer Correct ?    7 Yes 2 No

Difference between IN and EXISTS..

Answer / anju saxena

The EXISTS operator tests whether a given set is empty or
not. An exist operator on empty set returns False while on
nonempty set it returns True.
IN operator is used where membership of the element has to
tested against the set.

Is This Answer Correct ?    8 Yes 4 No

Difference between IN and EXISTS..

Answer / subathra

IN: Inner query executes first and drives the outer query.
EXISTS: Outer query executes first and compares tge rows
retrived with the inner query.
Consider table tab1 has 1000 rows and table tab2 has 1000
rows.
IN: select t1.empid from tab1 t1 where t1.code in (select
t2.code from tab2 t2) -- All rows in t1 will read with t2
and the effect is 1000 X 1000 rows.
EXISTS: select t1.empid from tab1 t1 where exists (select 1
from tab2 t2 where t1.code=t2.code) -- Max of 1 row will be
read for each row of t1 and thus reduces the processing
overhead.
Thumb rule:
1) If the majority of the filtering are in the sub query
then use IN.
1) If the majority of the filtering are in the outer query
then use EXISTS.

Is This Answer Correct ?    4 Yes 0 No

Difference between IN and EXISTS..

Answer / yaswanth

IN looks for specified value and
EXISTS looks for whether particular row exists or not

Is This Answer Correct ?    2 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

what is the difference between binary_integer and pls_integer

2 Answers   TCS,


How long it takes to learn pl sql?

0 Answers  


what is 'mysqlcheck'? : Sql dba

0 Answers  


Is a secondary key the same as a foreign key?

0 Answers  


How do I use google cloud in sql?

0 Answers  






What are the different ways to optimize a sql query?

0 Answers  


Does group by remove duplicates?

0 Answers  


How do you concatenate in sql?

0 Answers  


What are wait events. Describe the wait event tables.

1 Answers   CTS,


what is the difference between primary key and unique key? : Sql dba

0 Answers  


Why do we use procedures in sql?

0 Answers  


What are user defined functions?

0 Answers  






Categories