题解 | #获取当前薪水第二多的员工号及其对应的薪水#

#套娃
select emp_no,salary from salaries where salary=(

select 
    max(a.salary)
from  
    salaries a
where 
    a.emp_no<>
    (
        select 
            emp_no 
        from 
            salaries 
        where 
            salary=
            ( 
            select 
                max(salary) 
            from 
                salaries 
                )
            )
)
;