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 the difference between sql and mysql?

768


List the ways to get the count of records in a table?

661


What are sql procedures?

765


Explain the uses of control file.

793


Can %notfound return null after a fetch?

767


What are its different types of dbms?

719


What is the use of desc in sql?

702


what is sql profiler? : Sql dba

800


What is dynamic query?

740


Explain the structure of pl/sql in brief.

805


Explain the select statement in sql?

834


Is null operator in sql?

799


Does pdo prevent sql injection?

708


Explain constraints in sql?

777


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1742