select t.*,
dense_rank()over(partition by t.id order by t.score desc) as “不间断排序”,
rank() over(partition by t.id order by t.score desc) as “间断排序”,
ROW_NUMBER()over(partition by t.id order by t.score desc) as “行号”
from dan_test t
oracle排序查询
最新推荐文章于 2024-04-17 17:55:20 发布