select emp_no,salary
from salaries
where salary = (
    select salary
    from salaries
    order by salary desc
    limit 1 offset 1
)

考察子查询，注意题目可能有多个员工并列第二，所以需要先找到第二多的工资，然后筛选