SELECT employees.emp_no,salaries.salary,employees.last_name,employees.first_name from employees join salaries on employees.emp_no=salaries.emp_no where salary=(select max(salary) from salaries where salary <(select max(salary) from salaries));

1.在salaries表中查出薪水最大值 2.排除这个值之后再查出薪水最大值 3.employees和salaries 内连接，筛选其中salary 等于上一步中查询出的薪水值。