select s.emp_no ,max(s.salary),e.last_name,e.first_name from employees e inner join salaries s on e.emp_no=s.emp_no where s.to_date='9999-01-01' and s.salary in( select max(s2.salary) from salaries s2 where s2.to_date='9999-01-01'and s2.salary not in (select max(s1.salary) from salaries s1))

排除最大的，那么剩下的里面，最大的就是第二大的