题解 | 用子查询实现order by的功能

SELECT
    E.emp_no,
    S.salary,
    E.last_name,
    E.first_name
FROM
    employees E
    LEFT JOIN salaries S ON E.emp_no = S.emp_no
    JOIN (
        SELECT
            MAX(salary) secondMaxSalary
        FROM
            salaries
        WHERE
            salary < (
                SELECT
                    MAX(salary)
                FROM
                    salaries
            )
    ) T ON S.salary = T.secondMaxSalary