Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLcorrelated subqueriesSingle-choice MCQ

In PostgreSQL, what does a correlated subquery's correlation actually mean for execution semantics?

SELECT e.name FROM employees e WHERE e.salary > ( SELECT AVG(d.salary) FROM employees d WHERE d.dept_id = e.dept_id );