利用MySQL游标进行计算排名

SELECT
  a.id,
  a.nick_name,
  a.member_account,
  a.integral,
  (@rowNum := @rowNum + 1) AS tRank #计算行号
 FROM
  tzqc_raw_data AS a,
  (SELECT
    (@rowNum := 0)) b
WHERE a.groups = 1
  AND a.date =
  (SELECT
    c.date
  FROM
    tzqc_raw_data c
  ORDER BY c.date DESC
  LIMIT 1)
ORDER BY a.integral DESC;

 

转载于:https://www.cnblogs.com/yanglei-xyz/p/10333865.html