select a.emp_no,max(a.salary) as salary,b.last_name,b.first_name
from salaries a
left join employees b
on a.emp_no=b.emp_no
where a.salary<(select max(salary) from salaries)

两次取最大值