178
SELECT Score,
dense_rank() over(order by Score desc) as 'Rank'
FROM Scores
row_number() over(order by 列名)
rank() over(order by 列名)
dense_rank() over( order by 列名)
row_number():不考虑数据的重复性 按照顺序一次打上标号
如: 1,2,3,4
RANK()是跳跃排序,
如:1 2 2 4,会跳过3
DENSE_RANK()是连续排序,
如:1 2 2 3 序号连续