第一步剔除工资最高的记录，即 WITH a AS ( SELECT * FROM salaries WHERE salary < (SELECT MAX(salary) FROM salaries) )

第二步从剩下的记录里面选出工资最高的选项，即第二高工资 SELECT a.emp_no ,salary,last_name ,first_name FROM a left join employees e on a.emp_no=e.emp_no WHERE salary = (SELECT max(salary) FROM a)