题解 | 获取当前薪水第二多的员工的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;
相关推荐