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

双重select聚合函数取max

select a.emp_no,b.salary,a.last_name,a.first_name
from employees a,salaries b 
where a.emp_no=b.emp_no and b.salary=(
    select max(salary)
    from salaries
    where salary not in (
        select max(salary)
        from salaries
    )
);