MAX in WHERE Clause
Why can't you use MAX() directly in a WHERE clause?
-- This doesn't work:
SELECT e.ename
FROM Emp e
JOIN Dept d ON e.eid = d.managerid
WHERE d.budget = MAX(d.budget);
Sign in to answer questions and track your progress
Sign In