178. 分数排名

我要去看得最远的地方

已于 2023-05-24 20:24:30 修改

阅读量86

点赞数

文章标签：数据库 sql mysql

于 2023-05-24 20:22:09 首次发布

本文链接：https://blog.csdn.net/qq_42434171/article/details/130854691

版权

#方法一
select s2.score,num as `rank` from Scores s2,
(select s.score,@rank1:=@rank1+1 as num  from (select distinct s3.score from Scores s3 order by score desc) s ,(SELECT @rank1:= 0) r) q 
 where s2.score=q.score order by s2.score desc

#方法二
select a.score,a.id as `rank` from (select s.score,@rank1:=@rank1+1 as id  from (select distinct s3.score from Scores s3 order by score desc) s ,(SELECT @rank1:= 0) r) a ,(select s.score,@rank2:=@rank2+1 as id  from (select s3.score from Scores s3 order by score desc) s ,(SELECT @rank2:= 0) r) b  WHERE a.score = b.score