Sql Server 2008

Sql Server 2008

A subquery—also referred to as an inner query or inner select—is a SELECT statement embedded within a data manipulation language (DML) statement or nested within another subquery. You can use subqueries in SELECT, INSERT, UPDATE, and DELETE statements wherever expressions are allowed. For instance, you can use a subquery as one of the column expressions in a SELECT list or as a table expression in the FROM clause.

A DML statement that includes a subquery is referred to as the outer query. The following guidelines provide details about how to implement subqueries in your outer queries or in other subqueries:

• You must enclose a subquery in parenthesis.
• A subquery must include a SELECT clause and a FROM clause.
• A subquery can include optional WHERE, GROUP BY, and HAVING clauses.
• A subquery cannot include COMPUTE or FOR BROWSE clauses.
• You can include an ORDER BY clause only when a TOP clause is included.
• You can nest subqueries up to 32 levels.

There are several ways you can categorize subqueries—by the number of results they returns, whether they’re correlated (linked to the outer query), or where they’re used within a DML statement.