[LeetCode]Second Highest Salary-limit offset介绍

在员工工资表中返回第二高的记录，如果没有则返回null。

使用limit offset

SELECT
    (SELECT DISTINCT
            Salary
        FROM
            Employee
        ORDER BY Salary DESC
        LIMIT 1 OFFSET 1) AS SecondHighestSalary
;

 使用ifnull函数：

SELECT
    IFNULL(
      (SELECT DISTINCT Salary
       FROM Employee
       ORDER BY Salary DESC
        LIMIT 1 OFFSET 1),
    NULL) AS SecondHighestSalary

limit和offset详解 

(1)select * from table limit 2,1;

(2)select * from table limit 1 offset 1;

1.limit X 是选取X个数据，offset Y 是跳过Y个数据

2.limit  X,Y  中X表示跳过X个数据，读取Y个数据