Correlated subquery « Subquery « SQL Server / T-SQL

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