在leecode上做了一道题

在leecode上做了一道题：
找出排名第二高的工资
Employee Salary

不熟悉LIMIT OFFSET和mysql的我，做了好久

最后看了答案
答案是这样的：
select
(
select distinct Salary SecondHighestSalary from Employee
order by Salary desc
limit 1 offset 1) as SecondHighestSalary ;
或者
select
IFNULL(
select distinct Salary SecondHighestSalary from Employee
order by Salary desc
limit 1 offset 1),NULL) as SecondHighestSalary ;

这个是为了只有1条记录的时候 要弄出一个
SecondHighestSalary
NULL
的行。。。不懂 很迷