select Score,(select count(distinct score) from scores where score>=t1.Score ) as Rank from scores t1 order by t1.score desc
另外在mysql中 好像是没有dense_rank()等函数的
leecode sql No.178 分数排名
最新推荐文章于 2021-03-17 20:48:58 发布
select Score,(select count(distinct score) from scores where score>=t1.Score ) as Rank from scores t1 order by t1.score desc
另外在mysql中 好像是没有dense_rank()等函数的