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

select a.emp_no,b.salary,a.last_name,a.first_name 
from  employees a join salaries b 
on a.emp_no=b.emp_no 
where salary=
    (
        select max(salary) 
        from  salaries 
        where salary<
            ( 
            select max(salary) 
            from  salaries
            )
    );