Difference between IN and EXISTS

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to revise and re-run the last sql command?

647


What are the features of pl sql?

559


What is cascade in sql?

559


Can we use ddl statements in stored procedure?

696


What is left join in sql?

582






Is pl sql useful?

537


How many rows can sqlite handle?

586


What is acid property in a database?

586


What is error ora-12154: tns:could not resolve the connect identifier specified?

590


How to know the last executed procedure?

586


What is a constraint?

565


What is the difference between the conventional and direct path loader? : aql loader

650


Is grant a ddl statement?

452


How can I see all tables in sql?

543


what is row? : Sql dba

707