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

即先查询到最大薪资，然后将其排除掉，剩余信息中最大的便是整体第二大的