A SELECT statement nested inside another SQL statement. Correlated subqueries can be slow on large tables; rewriting them as JOINs or CTEs often produces better execution plans.
