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

二刷 简单