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]
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]