基础编程
sql语句，having优化
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区sql中的having速度很慢，怎么优化呢？
SELECT sd.send_detail_id, sd.amount, SUM(IFNULL(pb.qty,0)) AS c FROM p_host_send s INNER JOIN p_host_send_detail sd ON sd.send_id = s.send_id
LEFT JOIN p_host_boxcode pb ON sd.send_detail_id = pb.out_detail_id
WHERE s.send_id=8527 AND sd.part_id=1875 GROUP BY send_detail_id
HAVING c < amount
SELECT sd.send_detail_id, sd.amount, SUM(IFNULL(pb.qty,0)) AS c FROM p_host_send s INNER JOIN p_host_send_detail sd ON sd.send_id = s.send_id
LEFT JOIN p_host_boxcode pb ON sd.send_detail_id = pb.out_detail_id
WHERE s.send_id=8527 AND sd.part_id=1875 GROUP BY send_detail_id
HAVING c < amount
...全文
