题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

SELECT
    emp_no,
    salary
FROM
    (
        SELECT
            emp_no,
            salary,
            DENSE_RANK() OVER (ORDER BY salary DESC ) AS rn
        FROM
            salaries
    ) AS ranked
WHERE
    rn=2
ORDER BY
    emp_no ASC;