select e.emp_no,s1.salary,e.last_name,e.first_name from employees e
inner join salaries s1 on e.emp_no=s1.emp_no
where s1.salary=(select max(s2.salary) from salaries s2
where s2 .salary<>(select max(s3.salary) from salaries s3))