select com from(SELECT shipping_fedex, sum( goods_amount2 ) AS com
FROM bids_buy_info
GROUP BY shipping_fedex
) where com=0
希望将这个com=0的查询出来,正确的语句怎么写?
SELECT shipping_fedex, sum( goods_amount2 ) AS com
FROM bids_buy_info
GROUP BY shipping_fedex having com = 0