解题思路:计算大于等于自己的个数有多少作为自己的rank
select Score,(select count(*)
from (select distinct Score S from Scores) as tmp
where S >= Score) as Rank
from Scores
order by Score desc;
解题思路:计算大于等于自己的个数有多少作为自己的rank
select Score,(select count(*)
from (select distinct Score S from Scores) as tmp
where S >= Score) as Rank
from Scores
order by Score desc;