178. Rank Scores

问题描述

解决方案

select 
sc.Score,
(select count(*) from (select distinct Score from  Scores  ) ds where ds.Score>= sc.Score ) Rank  
from Scores sc 
order by Score desc