题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
select a.emp_no,a.salary from salaries a where a.salary =( select b.salary from salaries b order by b.salary desc limit 1,1 ) order by emp_no asc;
select a.emp_no,a.salary from salaries a where a.salary =( select b.salary from salaries b order by b.salary desc limit 1,1 ) order by emp_no asc;
相关推荐