select a.emp_no,
a.salary,
b.last_name,
b.first_name
from salaries a
inner join employees b
on  a.emp_no=b.emp_no
and a.to_date='9999-01-01'
and a.emp_no in
(select s1.emp_no 
from salaries s1 
inner join salaries s2
on s1.salary<=s2.salary
and s1.to_date='9999-01-01'
and s2.to_date='9999-01-01'
group by s1.emp_no
having count(*)=2);