Mysql分数排名（连续值）

1.构建一张表 

Create table If Not Exists Scores (Id int,Score DECIMAL(3,2));  
Truncate table Scores;  
insert into Scores (Id, Score) values ('1','3.5');  
insert into Scores (Id, Score) values ('2','3.65');  
insert into Scores (Id, Score) values ('3','4.0');  
insert into Scores (Id, Score) values ('4','3.85');  
insert into Scores (Id, Score) values ('5','4.0');  
insert into Scores (Id, Score) values ('6','3.65');

-- 查询去重后分数的，条件：当前行分数大于等于同表的分数的count数量，去重显示，然后降序输出
select Score, (select count(distinct Score) from Scores where Score>=s.Score) 
as Rank from Scores as s order by Score desc;  
-- 首先查找去重后的分数作为新表，使用count统计行，
-- 条件：当前去重表后的分数>=未去重的分数作为Rank的参数，然后使用排序降序输出
select Score,(select count(*) from (select distinct Score as s from Scores)
as new_scores where s >= Score) Rank from Scores order by Score desc;

# Write your MySQL query statement below
select Score,
(select count(distinct Score) from Scores where Score>=s.Score) Rank
from Scores s  order by Score DESC