[Solved] How to get a ranking result for special record in mysql [closed]
You want to get the rank in MySQL. Here is one approach: SELECT id, name, @rn := @rn+1 as `rank` from `users` cross join (select @rn := 0) const ORDER BY points desc 1 solved How to get a ranking result for special record in mysql [closed]