select *,(select SUM(Amount) from [iOrderDetail] where Ibccode=IbcGoods.Ibccode and PayState=0) as vAmt from Goods where vAmt > 0 order by vAmt desc
...全文
1558打赏收藏
销量排行的问题,这语句不对。。谁能帮助下?
商品销量排行,统计订单明细表该商品的销量。。销量为0的不显示。。 select *,(select SUM(Amount) from [iOrderDetail] where Ibccode=IbcGoods.Ibccode and PayState=0) as vAmt from Goods where vAmt > 0 order by vAmt desc
SELECT A.[iOrderDetail],SUM(B.Amount) AS vAmt
FROM Goods AS A
INNER JOIN [iOrderDetail] AS B
ON A.Ibccode=B.[iOrderDetail] AND B.PayState=0
WHERE B.Amount>0
GROUP BY A.[iOrderDetail]
ORDER BY vAmt DESC