Subqueries and set operations
Scalar, row, and correlated subqueries, EXISTS/NOT EXISTS for expressing "for all" logic, and UNION/INTERSECT/EXCEPT.
9 min readUpdated 2026-09-03dbmssqlsubqueriesset-operations
Scalar, row, and correlated subqueries, EXISTS/NOT EXISTS for expressing "for all" logic, and UNION/INTERSECT/EXCEPT.