题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#

找出当前薪水第二多的员工 先找出最高薪水

select max(salary) from salaries

然后再进行判断不是最高薪水 筛选后的最高薪水就是地第二高的薪水

select max(salary) from salaries
    where salary<>(select max(salary) from salaries)

最后判断等于第二高薪水 输出 emp_no和salary

select emp_no,salary from salaries
where salary=
(select max(salary) from salaries
    where salary<>(select max(salary) from salaries))
    order by emp_no