with t1 as
(select employees.emp_no ,salary,last_name ,first_name 
from employees join salaries using(emp_no )
where salary<(select max(salary) max_salary
from salaries))

select emp_no ,salary,last_name,first_name
from t1
where salary in 
(select max(salary) max_salary
from t1)