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