Difference between IN and EXISTS

Answer Posted / udaykumar

IN - returns a numeric value.
EXIT - returns a boolean value.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you load microsoft excel data into oracle? : aql loader

603


What is write ahead logging in sql server?

548


Do prepared statements prevent sql injection?

513


Can you have a foreign key without a primary key?

501


How to rename a column in the output of sql query?

521






What are the parts of a basic sql query?

494


how is exception handling handled in mysql? : Sql dba

534


What is compute?

542


What do you understand by exception handling in pl/sql?

562


What are the types of join in sql?

504


Does oracle use sql?

498


What kind of join is join?

543


Explain architecture of sql server notification services?

611


What is rownum in sql?

545


What is the difference between left join and right join?

491