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

What is scalar function?

559


Does access use sql?

551


Can you upgrade sql express to full sql?

506


Is left join and outer join same?

536


how to get a list of indexes of an existing table? : Sql dba

505






Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

709


what is bdb (berkeleydb)? : Sql dba

555


What are sql constraints?

557


How to prepare for oracle pl sql certification?

562


Which is faster joins or subqueries?

544


What is recursive join in sql?

537


How do I access sql anywhere database?

489


Can we use update in sql function?

569


What are pl sql procedures?

509


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

541