Difference between IN and EXISTS

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is string join?

546


Explain the the delete statements in sql?

569


Why is partition used in sql?

536


When is the explicit cursor used ?

582


What is PL/SQL Records?

614






What is a common use of group by in sql?

585


What are the rules to be applied to nulls whilst doing comparisons?

738


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

538


what is sql? : Sql dba

549


what are date and time data types in mysql? : Sql dba

487


How do you write an inner join query?

500


Why do we need pl sql?

538


What is cte sql?

508


what is the difference between union and union all? : Sql dba

534


what is error ora-03113: end-of-file on communication channel?

589