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

SELECT
    e.emp_no,
    s.salary,
    e.last_name,
    e.first_name
FROM
    employees AS e
    INNER JOIN
    salaries AS s ON e.emp_no=s.emp_no
WHERE
    s.salary=(
        SELECT
            MAX(salary)
        FROM
            salaries
        WHERE 
            salary<(
                SELECT
                    MAX(salary)
                FROM
                    salaries
            )
    )；