sql分组后条件查询
总数据量:48865菜菜的sql:缺点:数据量上来一个子查询拖垮性能 能不用就不用select *from(SELECT `user_id`, SUM(`reward_cash`) cashfrom `A`GROUP BY `user_id`) settle where settle.cash > 3000结果:正确的sql:SELECT user_id, SUM(reward_cash) AS cash FROM `A`GROUP BY `user_id`...
原创
2021-08-20 09:50:10 ·
1421 阅读 ·
0 评论