Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 the use of sql trace?

897


write an sql query to find names of employee start with 'a'? : Sql dba

967


What is pls integer?

985


what is bdb (berkeleydb)? : Sql dba

976


What is the difference between sql and t sql?

966


Can we use rowid as primary key?

944


How to create an array in pl/sql?

1015


What does select count (*) mean in sql?

964


How do we use distinct statement? What is its use?

977


Can we use pl sql in sql server?

1013


how to increment dates by 1 in mysql? : Sql dba

927


How to test for null values?

985


How do I partition a table in sql?

1045


what are aggregate and scalar functions? : Sql dba

996


How to use sql*plus built-in timers?

1097