use of IN/ANY/ALL

Answer Posted / satyajit patel

-> in------------ Looks to all values returned in sub-query

-> <any---------- looks to highest value in sub-query
-> >any---------- looks to smallest value in sub-query

-> <all---------- looks to smallest value in sub-query
-> >all---------- looks to highest value in sub-query

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the different types of indexes in sql?

563


What is a primary key? Explain

542


How do you modify a table in sql?

565


what is the difference between join and union? : Sql dba

548


how to get @@error and @@rowcount at the same time? : Sql dba

529






Why procedure is used in sql?

533


What are the advantages of pl sql?

605


what is the difference between cluster and non cluster index? : Sql dba

555


what is sql server agent? : Sql dba

603


Explain the update statement in sql

562


what are all the common sql function? : Sql dba

585


What are the two parts of design view?

581


How long does it take to learn pl sql?

608


What do you mean by dbms? What are its different types?

557


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

695