mysql排行榜sql的实现

SELECT num_rows
FROM (SELECT @rownum := @rownum + 1 AS num_rows, openid
    FROM (SELECT @rownum := 0, openid, money
        FROM lt_cash_user
        ) t
    ORDER BY money DESC
    ) t1
WHERE openid = 'oS77FjsN6hc-fWL1toDKyUM_uGTs'
原文地址:https://www.cnblogs.com/bossikill/p/3526587.html