请各位大佬看一下，为什么我的这个不对呀
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
select emp_no
s.salary salary,
last_name, first_name
from employees e join salaries s on e.emp_no = s.emp_no
where s.salary = (
select distinct salary
from salaries
order by salary desc
limit 1,1
)
投递科大讯飞等公司10个岗位