Correlated subquery « Subquery « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Subquery
  3. Correlated subquery
8.2.Correlated subquery
8.2.1.A correlated subquery relies on the main query for its processing.
8.2.2.using SELECT DISTINCT or a GROUP BY statement in the inner query
8.2.3.Correlated subquery using Group By
8.2.4.Correlated subquery using TOP 1