Correlated Subquery

Correlated Subquery

Correlated Subquery — A subquery that depends on the outer query. 

SELECT *
FROM employees AS e
WHERE salary > (
    SELECT AVG(salary) FROM employees 
    WHERE department = e.department
);

Related concepts

→
Correlated Subquery

Correlated Subquery — Structure map

Clickable & Draggable!

Correlated Subquery — Related pages:

SQL Subqueries