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...

What is a sub-query? When would you use one?

Answer Posted / swapna

Subquery is used to get information from a table based on
unknown conditions.
If select stmt not perform entire task using
selection,projection,and joins then we can perform that
type of task using sub queries.

Is This Answer Correct ?    3 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain user defined views?

963


Define cursor locking

1006


Explain table valued parameters in sql server? Why tvp used?

1019


What is the purpose of indexing?

1044


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2344


What options are available to audit login activity? : sql server security

1153


Why are sql functions used?

1119


What to check if a User database is locked?

1071


What is Service Broker in sql server 2012?

1020


What is a document index?

1028


How to bind a view to the schema of the underlying tables?

1001


what's the difference between a primary key and a unique key? : Sql server database administration

950


What is dknf in normalization form?

1052


Why would you use sql agent?

1263


can an order by clause be used in a creation of a view?

1183