Open yokostan opened 5 years ago
# Write your MySQL query statement below SELECT max(Salary) as SecondHighestSalary FROM Employee WHERE Salary < ( SELECT max(Salary) FROM Employee )
LIMIT 1 version does not handle null case, while max() handles.
LIMIT 1 version does not handle null case, while max() handles.