sql sub query
what is sql sub query? how can v use ...can any one explain
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Aug 7, 2012, 11:29 PM
A subquery is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another subquery. Subquery is an inner query or inner select, while the statement containing a subquery is also called an outer query or outer select.
Please refer
http://msdn.microsoft.com/en-us/library/aa213252%28v=sql.80%29.aspx
http://blog.sqlauthority.com/2010/06/07/sql-server-subquery-or-join-various-options-sql-server-engine-knows-the-best-part-2/
hope this will help you.
Santhosh Kumar JayaramanPosted Aug 7, 2012, 8:04 AM
http://www.simple-talk.com/sql/sql-training/subqueries-in-sql-server/
In simple sub query is an inner query.
For eg,
There are duplicate rows inside table and i want to find all columns for such a duplicate row..