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