mysql 当前用户的排名_mysql 如何查询当前用户所在排名

所有用户排名

SELECT b.* FROM

(

SELECT t.*, @rownum := @rownum + 1 AS rownum

FROM (SELECT @rownum := 0) r,

(SELECT y.id, u.`name`,u.openId,sum(bcdtfs) as sumScore FROM Sys_yhhd y INNER JOIN user u on y.openId = u.openId GROUP BY y.openid ORDER BY sumScore desc) AS t

) AS b ;

效果图

查询当前用户的排名

SELECT rownum FROM

(

SELECT t.*, @rownum := @rownum + 1 AS rownum

FROM (SELECT @rownum := 0) r,

(SELECT y.id, u.`name`,u.openId,sum(bcdtfs) as sumScore FROM Sys_yhhd y INNER JOIN user u on y.openId = u.openId GROUP BY y.openid ORDER BY sumScore desc) AS t

) AS b WHERE b.openId = '12214214' ;

加个where条件就可以

效果图