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

SELECT e.dept_no,d.emp_no,salary from salaries d 
inner join (#拉一张非管理员的员工清单
    SELECT a.emp_no,b.dept_no from employees a 
            LEFT join dept_emp b on a.emp_no=b.emp_no and b.to_date='9999-01-01'
    #连表条件为部门编号、员工编号都对应
           LEFT JOIN dept_manager c on c.dept_no=b.dept_no and c.emp_no=b.emp_no and b.to_date='9999-01-01'
           #where 条件筛除管理者
    where c.emp_no is null) as e
      on d.emp_no=e.emp_no and d.to_date='9999-01-01'
      where e.dept_no like 'd%'