mysql查询问题

Question

select com from(SELECT shipping_fedex, sum( goods_amount2 ) AS com
FROM bids_buy_info
GROUP BY shipping_fedex
) where com=0

希望将这个com=0的查询出来，正确的语句怎么写？

Answer 1

SELECT shipping_fedex, sum( goods_amount2 ) AS com
FROM bids_buy_info
GROUP BY shipping_fedex having com = 0