row_number()over() 和 rank()over()的区别_row number 和rank over

作者：羊村懒王 | 2024-03-15 12:16:11

踩

row number 和rank over

select employee.*,row_number()over(partition by deptid order by salary desc) rank from employee;

select employee.*,rank()over(partition by deptid order by salary desc) rank from employee;

本文内容由网友自发贡献，转载请注明出处：https://www.wpsshop.cn/w/羊村懒王/article/detail/240779