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) 两次取最大值