第二高的薪水 

方法一：
SELECT
    IFNULL(
        (
            SELECT DISTINCT
                Salary
            FROM
                Employee
            ORDER BY
                Salary DESC
            LIMIT 1 OFFSET 1
        ),
        NULL
    ) AS SecondHighestSalary;
方法二：
SELECT
    MAX(Salary) AS SecondHighestSalary
FROM
    Employee
WHERE
    Salary < (
        SELECT
            MAX(Salary)
        FROM
            Employee
    );

 

posted @ 2018-07-27 16:00  han_shan_chang  阅读(202)  评论(0)    收藏  举报