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
Sunday, November 1, 2009
Subscribe to:
Post Comments (Atom)
[ROM] Samsung S7 Stock Firmware BRI (Taiwan台灣)
Latest ROM: G930FXXU1DQEU Download: https://kfhost.net/tpl/firmwares.php?record=B7E6DE774E3811E7963AFA163EE8F90B Reference: http://...
-
In Android 4.1 (API 16) and above, MediaCodec is introduced by Android. By using MediaCodec, we can easily decode video without using Androi...
-
#include <sstream> #include <assert.h> // include in android platform-9 or newer #include <android/asset_manager.h> #inclu...
-
Latest ROM: G930FXXU1DQEU Download: https://kfhost.net/tpl/firmwares.php?record=B7E6DE774E3811E7963AFA163EE8F90B Reference: http://...
No comments:
Post a Comment