第一种排序方式:并列不加1
select
s1.Score,
(select count(distinct s2.Score) from Scores as s2 where s2.Score >= s1.Score) as Rank
from
Scores as s1
order by Score desc
第二种排序方式:并列加1
select
s1.Score,
(select 1+count( s2.Score) from Scores as s2 where s2.Score > s1.Score) as Rank
from
Scores as s1
order by Score desc