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