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 are hotfixes and patches?

527


Can sql developer connect to db2?

584


Is it possible to create startup or shutdown trigger for on-schema?

584


How do you remove duplicate records from a table?

510


Why is sql better than hql?

506






how to extract a unit value from a date and time? : Sql dba

556


How does a trigger work?

533


Can we join more than 2 tables in sql?

489


Why do we use %rowtype & %type in plsql?

603


How do I count rows in sql?

559


Define commit, rollback and savepoint?

574


Why coalesce is used in sql?

470


explain the difference between bool, tinyint and bit. : Sql dba

520


how to enter characters as hex numbers? : Sql dba

568


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

665