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

遇到这种题，对所求属性有条件而且比较复杂的，一般直接子查询