178.Rank Scores

[chen_1027]

select Scores.Score,c.rank from Scores left join (select Score,(@i:=@i+1) as Rank from (select distinct Score from Scores Order By Score DESC) as b,(select @i:=0) as a ) as c on Scores.Score = c.Score order by c.Score DESC;