Sunday, November 1, 2009

MySQL: Rank calculation

SELECT ID,
@rank := COALESCE(
NULL + (@prev := @curr),
NULL + (@curr := r.score),
NULL + (@counter := @counter+1),
IF(@prev = @curr, @rank, @counter)
) AS Rank

FROM
(SELECT @curr:=null,@prev:=null,@rank:=0,@counter:=0) sel1,
Record AS r

ORDER BY r.score DESC

[ROM] Samsung S7 Stock Firmware BRI (Taiwan台灣)

Latest ROM: G930FXXU1DQEU Download: https://kfhost.net/tpl/firmwares.php?record=B7E6DE774E3811E7963AFA163EE8F90B Reference: http://...