可以使用 dense_rank()的开窗函数
例: table1
name score
botter 80
herry 80
lily 99
select name,score,dense_rank() over (partition by score order by score) as rank_id from table1
得到的结果:
name score rank_id
lily 99 1
botter 80 2
herry 80 2
可以使用 dense_rank()的开窗函数
例: table1
name score
botter 80
herry 80
lily 99
select name,score,dense_rank() over (partition by score order by score) as rank_id from table1
得到的结果:
name score rank_id
lily 99 1
botter 80 2
herry 80 2