SELECT * FROM (SELECT SUM(求和的数据) (别名),(字段名(可加可不加)) FROM (表名) GROUP BY user_id ) AS a ORDER BY a.userSum DESC LIMIT 10
根据每个用户的Id进行分组求和
最新推荐文章于 2022-03-20 18:42:45 发布
SELECT * FROM (SELECT SUM(求和的数据) (别名),(字段名(可加可不加)) FROM (表名) GROUP BY user_id ) AS a ORDER BY a.userSum DESC LIMIT 10