- SQL Server Subqueries
- SQL Server Correlated Subqueries
- SQL Self-Contained Subqueries
Subqueries allow you to nest queries. One query operates on the results of another query. Another way to accomplish the same thing as a subquery is to use intermediate objects, such as variables. A subquery is one type of multi-table query.
There are two types of subqueries: self-contained subqueries or correlated subqueries. There is also the EXISTS predicate.