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

select aa.emp_no,salary,last_name,first_name from 
(select *,maxs-salary dis from (select emp_no,salary,(select max(salary) from salaries ) maxs from salaries) a where maxs-salary > 0 ) aa
left join employees on aa.emp_no = employees.emp_no
where aa.dis = (select min(dis)from (select *,maxs-salary dis from (select emp_no,salary,(select max(s.salary) from salaries s) maxs from salaries) a where maxs-salary > 0) b);