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

1、查询出第几高的薪水（第二高），可通用 select s1.salary from salaries s1,salaries s2 where s1.salary <= s2.salary group by s1.salary having count(distinct s2.salary) = 2

2、查询薪水等于第二高的薪水的员工数据 select e.emp_no , salary, last_name, first_name from employees e left join salaries s on s.emp_no = e.emp_no where s.salary = (select s1.salary from salaries s1,salaries s2 where s1.salary <= s2.salary group by s1.salary having count(distinct s2.salary) = 2)