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

select emp_no ,salary,last_name,first_name
from employees join salaries using(emp_no)
where salary in (
    select max(salary)
		from salaries
		where salary not in (select max(salary) from salaries)

)