最高工资可能有多个人, 先拿到最高工资的值, 在把这个值当作条件查员工编号和工资

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