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

Given a correlated subquery in the SELECT list, what does this query return for each employee?

SELECT e.name, (SELECT COUNT(*) FROM employees e2 WHERE e2.dept_id = e.dept_id AND e2.salary > e.salary) + 1 AS dept_salary_rank FROM employees e;