Types of Sub-Queries

A sub-query is a query inside another query, in parentheses. An uncorrelated one runs once on its own; a correlated one uses the outer query's row and runs once per row.

Updated

Cheat sheet: Types of Sub-Queries
Category
SQL
Level
Journeyman
Tags
Correlated Subquery, sql, Subquery, t-sql