with diergao as
(select max(salary)as dier from salaries 
where salary<(select max(salary) from salaries))

select e.emp_no,s.salary,e.last_name,e.first_name
from employees e 
join salaries s on e.emp_no = s.emp_no
where  s.salary = (select dier from diergao)

这道题要是用了order by会报错的，窗口函数也不能用，所以第二高=小于最高的最高，where salary<(select max(salary) from salaries))