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

我的方法：排序窗口函数

select emp_no,salary from (select emp_no,salary,dense_rank()over(order by salary desc) r from salaries)t where r=2 order by emp_no

法二：distinct+limit

select emp_no,salary from salaries where salary=(select distinct salary from salaries order by salary desc limit 1,1) order by emp_no

法三：group by+limit

select emp_no,salary from salaries where salary=(select salary from salaries group by salary order by salary desc limit 1,1) order by emp_no