Correlated Subquery in ORDER BY
448221Nov 28 2005 — edited Nov 30 2005The following is a valid sql. But, what is meant by a correlated scalar subquery in the ORDER BY clause?
SELECT employee_id, last_name
FROM employees e
ORDER BY (SELECT department_name
FROM departments d
WHERE e.department_id=d.department_id);