Mysql 统计排名(可并列)

最新推荐文章于 2024-06-24 11:08:24 发布

weixin_33766168

最新推荐文章于 2024-06-24 11:08:24 发布

阅读量796

点赞数

文章标签：数据库 python java

原文链接：https://my.oschina.net/u/574036/blog/2876092

版权

2019独角兽企业重金招聘Python工程师标准>>>

SELECT ct.pid, ct.betcount, ct.rownum, ou.vaddress FROM
(
SELECT a.pid,a.betcount,
CASE WHEN @rowtotal = a.betcount THEN @rownum
WHEN @rowtotal := a.betcount THEN @rownum := @rownum + 1
WHEN @rowtotal = 0 THEN @rowtotal :=@rownum + 1
END AS rownum FROM
(SELECT rpid AS pid, COUNT(pid) AS betcount FROM one_bet WHERE rpid <> 0 AND rid = 1 GROUP BY rpid ORDER BY betcount DESC) AS a,
(SELECT @rownum := 0 ,@rowtotal := NULL) r
) ct LEFT JOIN one_user ou ON ct.pid = ou.pid;

转载于:https://my.oschina.net/u/574036/blog/2876092