select s.emp_no, s.salary
from salaries s
where s.to_date='9999-01-01'
order by s.salary desc
limit 1, 1
nowcoder- sql-17-获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
最新推荐文章于 2021-09-09 08:46:21 发布
select s.emp_no, s.salary
from salaries s
where s.to_date='9999-01-01'
order by s.salary desc
limit 1, 1