select s.emp_no,s.salary,e.last_name,e.first_name 
from salaries s left join employees e 
on s.emp_no=e.emp_no  
where s.salary=(select max(salary) from salaries where salary != (select max(salary) from salaries))