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

how to create a new table in mysql? : Sql dba

1035


How do I remove all records from a table?

1119


What is trigger and stored procedure in sql?

1094


Why having clause is used in sql?

1022


Is natural join same as inner join?

987


how can we repair a mysql table? : Sql dba

1043


Is left join same as inner join?

1219


What is exit statement?

1064


how many groups of data types? : Sql dba

1078


what is a trigger in mysql? : Sql dba

1216


What is the difference between explicit and implicit cursors in oracle?

1116


What is where clause in sql?

1088


How can I tell if sql is running?

1134


what are the limitations of identity column? : Transact sql

1163


How many types of tables are there?

997