2 out of 3 rated this helpful - Rate this topic

Subquery Types

SQL Server 2008

Other Versions

Subqueries can be specified in many places:

With aliases. For more information, see Subqueries with Aliases.
With IN or NOT IN. For more information, see Subqueries with IN and Subqueries with NOT IN.
In UPDATE, DELETE, and INSERT statements. For more information, see Subqueries in UPDATE, DELETE, and INSERT Statements.
With comparison operators. For more information, see Subqueries with Comparison Operators.
With ANY, SOME, or ALL. For more information, see Comparison Operators Modified by ANY, SOME, or ALL.
With EXISTS or NOT EXISTS. For more information, see Subqueries with EXISTS and Subqueries with NOT EXISTS.
In place of an expression. For more information, see Subqueries Used in Place of an Expression.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions