新增一列排序

select s1.Score,count(distinct(s2.Score)) as rank
from Scores s1,Scores s2
where s1.Score<=s2.Score
group by s1.Id 
order by rank

count(distinct(s2.Score)) as rank统计S2表符合条件的不重复的分数的数量作为排名
group by S1.id # S1表中每个数据都进行排名

select s1.score,
(
   select count(*)+1
   from (select distinct score from scores) as s2
   where s2.score>s1.score
)
as rank
from scores s1
order by rank

在where 的条件限制下，count(*)比count(__)的效率更高