select a.emp_no,a.salary from (select *, dense_rank()over( order by salary desc) as r from salaries s) as a where a.r=2 order by a.emp_no 易错点： 1.dense_rank（）并列且连续排序 2.窗口函数不要进行partition by得内部再分组