select score, (select count(distinct score) from Scores s2 where s1.score <= s2.score) as "rank"
from Scores s1
order by score desc;
#因为考虑要增加一行,所以要取计算排名然后取别名:rank
#相同的分数统一排名,所以要先去重distinct,计算个数用count,判断另一个表S2有多少个比S1的分数大,给它订排名
#最后要降序 desc
select score, (select count(distinct score) from Scores s2 where s1.score <= s2.score) as "rank"
from Scores s1
order by score desc;
#因为考虑要增加一行,所以要取计算排名然后取别名:rank
#相同的分数统一排名,所以要先去重distinct,计算个数用count,判断另一个表S2有多少个比S1的分数大,给它订排名
#最后要降序 desc