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()等函数的
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()等函数的