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

1.根据 salaries 表求 max(salary);
2.求 where 条件满足 < max(salary) 的 max(salary),即为第二高的薪水;
3.inner join 两表，select 出需要字段;
4.where 条件为=第二步中求出的第二高薪水

select employees.emp_no
      ,salaries.salary
      ,employees.last_name
      ,employees.first_name
from employees
inner join salaries
on employees.emp_no=salaries.emp_no
where salaries.salary=(select max(salary) 
                       from salaries
                       where salary<(select max(salary) from salaries))