rank()
select rank() over (order by addedMember),* from acc_brand order by brandId desc
当order by (列名) (如:addedMember) 的值相同时,rank()的 会相同, 跳过一些序号,比如下图中没有3 ,同样,还会跳过另一些值
select rank() over (order by brandId),* from acc_brand order by brandId desc
当order by (列名) 的值 不相同时,rank()结果会正常显示
select dense_rank() over (order by addedMember),* from acc_brand order by brandId desc
dense_rank() 进行的排序会依次加1 ,不加跳过一些序号
