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

with max_salary_t as(
    select 
        max(salary) as max_salary
    from salaries
),
second_salary_t as(
    select 
        max(salary) as second_salary
    from salaries,max_salary_t
    where salary !=max_salary
)
select 
    e.emp_no,
    salary,
    last_name,
    first_name
from employees e 
    join salaries s using(emp_no)
    join second_salary_t st on s.salary=st.second_salary;