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

Explain the difference between 'between' & 'and' operators in sql

522


What is the plv (pl/vision) package offers?

605


what is dbms? : Sql dba

534


how to dump a table to a file with 'mysqldump'? : Sql dba

543


What is keys and its types?

531






How many types of normalization are there?

483


What is %type in sql?

506


What is the difference between sql and t sql?

531


What does (+) mean in sql joins?

515


Why is sharding used?

542


What are primary key and foreign key and how they work?

541


How many types of privileges are available in sql?

729


What are some predefined exceptions in pl/sql?

543


Why we use pl sql?

524


What do you know by pl/sql cursors?

556