计算用户排名,可以使用存储过程来计算,比如通过用户积分的高低,来为用户排名。
set @mycnt = 0;
SELECT * FROM (
SELECT t.id,(@mycnt := @mycnt + 1) as rank FROM clients t ORDER BY t.points desc ) a where a.id=2 ORDER BY id
计算用户排名,可以使用存储过程来计算,比如通过用户积分的高低,来为用户排名。
set @mycnt = 0;
SELECT * FROM (
SELECT t.id,(@mycnt := @mycnt + 1) as rank FROM clients t ORDER BY t.points desc ) a where a.id=2 ORDER BY id