Correlated subquery « Subquery « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Subquery
  3. Correlated subquery
1.WHERE clause in the subquery's SELECT statement links the inner query to the outer query
2.Correlated subquery using the department table in both inner and outer queries
3.Correlated subquery: the inner query depends on the outer query for any of its values
4.Correlated subquery using Distinct
5.Leaf-Level Employees (Employees with No Subordinates), Correlated Subquery Syntax
6.Leaf-Level Employees (Employees with No Subordinates), Join Syntax