题解 | top2的薪水排名

请问跟上一题有什么区别
select department,employee_name, salary
from(
select department,employee_name, salary,rank()over(partition by department order by salary desc) as rn
from employees
)t
where rn<=2
order by department  , salary desc

请问跟上一题有什么区别