分析:
实现:
方法一 select ( select distinct salary from Employee order by salary desc limit 1,1 )as SecondHighestSalary
方法二 SELECT IFNULL( (SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT 1 OFFSET 1), NULL) AS SecondHighestSalary
分析:
实现:
方法一 select ( select distinct salary from Employee order by salary desc limit 1,1 )as SecondHighestSalary
方法二 SELECT IFNULL( (SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT 1 OFFSET 1), NULL) AS SecondHighestSalary