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=
(select salary
from salaries
where to_date='9999-01-01'
group by salary
order by salary desc
limit 1,1)