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

How do you take the union of two tables in sql?

605


How is use pl and sql?

642


What does the base_object_type column shows in the user.triggers data dictionary view?

660


What is the most common sql injection tool?

632


what is oltp (online transaction processing)? : Sql dba

631






what is isam? : Sql dba

669


Do stored procedures prevent sql injection?

648


How do I remove sql plus from windows 10?

663


What is delimiter sql?

630


what are the join types in tsql? : Transact sql

666


What is difference between stored function and application function?

674


Can we use joins in subquery?

659


Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

765


What is left join example?

592


What is a temporal table?

583