SELECT
( SELECT DISTINCT salary
FROM Employee
ORDER BY salary DESC
LIMIT 1, 1 )
AS SecondHighestSalary
表示从salary的第二个数据开始,只取一位数
SELECT
( SELECT DISTINCT salary
FROM Employee
ORDER BY salary DESC
LIMIT 1, 1 )
AS SecondHighestSalary
表示从salary的第二个数据开始,只取一位数