方法1、
SELECT
IFNULL(MAX(Salary), NULL) SecondHighestSalary
FROM
Employee
WHERE Salary <
(SELECT
MAX(Salary)
FROM
Employee)
方法2、
SELECT DISTINCT
(Salary) AS SecondHighestSalary
FROM
Employee
UNION
SELECT
NULL
ORDER BY SecondHighestSalary DESC
LIMIT 1, 1