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

Comments

Post a Comment

Popular posts from this blog

Play video inside OpenGL ES by using MediaCodec

In Android 4.1 (API 16) and above, MediaCodec is introduced by Android. By using MediaCodec, we can easily decode video without using Android NDK, like creating video playback application, etc. In game development, video is also needed to make the game environment more realistics, like when you are playing a racing game with video banner around the track. In here, I'll introduce of how to decode the video and render it into OpenGL ES. Firstly, we prepare some stuffs to decode the video, like MediaExtractor and MediaCodec. private boolean initExtractor() { extractor = new MediaExtractor(); try { extractor.setDataSource(mFilePath); } catch (IOException e) { return false; } // get video track for (int i = 0; i < extractor.getTrackCount(); i++) { MediaFormat format = extractor.getTrackFormat(i); String mime = format.getString(MediaFormat.KEY_MIME); if (mime.startsWith("video/")) { ...
Read more