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

What is the purpose of object explorer and its features? : sql server management studio

1121


Difference between DELETE and TRUNCATE?

1002


how to create “alternate row colour”?

142


How do I create a trace in sql server?

960


What are the mathematical functions supported by sql server 2005?

996


what's the information that can be stored inside a bit column? : Sql server database administration

965


Explain four layers of abstraction microsoft architectured?

147


What are the types of lock supported by ?

995


How you can change the database name in SQL SERVER?

1132


What is relationship? What number of sorts of relationship are there?

1063


What is set nocount on?

893


What are the different Topologies in which Replication can be configured?

1118


Explain about Views?

1007


What do you mean by an execution plan? Why is it used?

952


What is normalization and its types?

963