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

select 
e.emp_no
,salary
,last_name
,first_name
from employees e join salaries s on e.emp_no=s.emp_no
where salary = 
(
    select max(salary) 
    from salaries 
    where salary != 
                    (
                        select max(salary) 
                        from salaries
                    )
)

思路：排除最大的薪水之后，再求最大的薪水