select em.emp_no,salary,last_name,first_name from employees em,salaries sa where sa.emp_no=em.emp_no and salary=(SELECT max(salary) from salaries where salary<(SELECT max(salary) from salaries)) ;