获取当前薪水第二多的员工信息

不用order by 就需要考虑最大值的次大值

先找出最大值

在根据最大值找出次大值

然后进行查询即可

select e.emp_no,salary,e.last_name,e.first_name  # 通过内连接进行查询
from employees e
inner join salaries s
on e.emp_no = s.emp_no and s.salary = 
    (select max(salary) as salary  # 找出小于最大值的次大值
    from salaries
    where salary < (select max(salary)   # 找出最大值
                   from salaries
                   where to_date = '9999-01-01')
    )