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

Can a composite key be null?

978


What is a field in a database?

1065


what are the difference between clustered and a non-clustered index? : Sql dba

1033


Is primary key an index?

991


How do I partition in sql?

964


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1072


how to run 'mysql' commands from a batch file? : Sql dba

1120


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1067


what is the command line end user interface - mysql? : Sql dba

981


how to shut down the server with 'mysqladmin'? : Sql dba

1012


Which is better join or subquery?

1137


Explain alias in sql?

1051


How do you use a while loop in pl sql?

1014


Are left and right joins the same?

1088


How do I upgrade sql?

1001