Skip to content

Instantly share code, notes, and snippets.

@boj

boj/user_rank.sql

Created April 24, 2010 10:14
Show Gist options
  • Save boj/377573 to your computer and use it in GitHub Desktop.
Save boj/377573 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
user_rank.sql
SELECT id, username, exp, money, @prev := @curr, @curr := money, @rank := IF(@prev = @curr, @rank, @rank+1) AS rank FROM users, (SELECT @curr := null, @prev := null, @rank := 0) sel1 ORDER BY money DESC LIMIT 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment