首页 > mysql查询问题

mysql查询问题

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
【热门文章】
【热门文章】