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

with t as (
    select a.emp_no, salary, last_name, first_name
    from employees a join salaries b on a.emp_no=b.emp_no
), t1 as (
    select max(salary) as second_salary
    from t
    where salary<>(select max(salary) from t)
)
select emp_no, salary, last_name, first_name
from t
where salary = (select second_salary from t1)