sql---排列函数

rank() && dense_rank()

1.rank()

排名按照1,2,2,4,5,6

select score,rank() over(order by S.score desc) as "rank"
from Scores S

2.dense_rank()

排名按照1,2,2,3,4,5

select score,dense_rank() over(order by S.score desc) as "rank"
from Scores S