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

Enlist some predefined exceptions?

1038


How can you fetch common records from two tables?

1046


What are the parts of a sql statement?

1072


What is full form of rtm?

990


What is a schema? How is it useful in sql servers?

1096


can a stored procedure call itself or recursive stored procedure? : Sql dba

1009


Is sql port 1433 encrypted?

1010


What is pl sql script?

1011


how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

958


Define join and name different types of joins?

988


What is the mutating table and constraining table?

1011


Does pl/sql support create command?

1087


What are the ddl commands?

990


What is oracle pl sql developer?

964


what is 'mysqlshow'? : Sql dba

1007