select a.salary from Employee a
WHERE a.salary <(select MAX(b.salary) from Employee b)
ORDER BY a.salary DESC
My solution: SELECT max(salary)
WHERE salary < (SELECT max(salary) FROM Employee);
also worked on my machine, but failed in leetcode?
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.