题解 | #获取当前薪水第二多的员工的

select
    s3.emp_no,
    s3.salary
from
    salaries s3
where
    s3.salary = (
        select
            Max(s1.salary)
        from
            salaries s1
        where
            s1.salary <> (
                select
                    Max(s2.salary)
                from
                    salaries s2
            )
    )
order by
    s3.emp_no