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

How to get the definition of a user defined function back?

1085


What is the difference between a function and a trigger?

1122


How to convert numeric values to integers in ms sql server?

1158


How to create nested stored procedure?

1071


What are security principals used in sql server 2005?

1036


How to assign new column names in a view?

957


What are the types of subscriptions in SQL Server replication?

1103


Explain microsoft sql server functions?

1177


What is normalization of database? What are its benefits?

1070


What is the difference between char, varchar and nvarchar?

1075


What is 1nf 2nf?

1058


Can we join two tables without primary key?

1092


On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1249


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1092


Why are you getting errors when creating a new odbc dsn?

1287