178.分数排名

Heidi SQL运行结果正确

思路为先select成不重复并带排名的表t,再与原表scores进行连接
其中为生成rank,搜索百度词条【MySQL生成序列号】，参考链接

set @rank=0;
select t.score, t.rank from (select @rank:=@rank+1 as rank,f.score from (select distinct score from scores order by score desc) as f) as t
right join scores
on t.score=scores.score
order by t.score desc

分解步骤，表t为：

再总结一下select 套娃的用法

select from (select var from table) as t