代码是这样的:
SELECT GoodsID,Profit FROM GoodsSellVolumnbyDay WHERE DateDay ='20130430' GROUP BY GoodsID,Profit ORDER BY Profit
结果是这样子的:这个语句要怎么改,才能把相同ID号的Profit加在一起呢?
比如说让原本这样的结果:
002 1.5
002 3
显示成:
002 4.5
呢?
求指导~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT GoodsID,Profit FROM GoodsSellVolumnbyDay WHERE DateDay ='20130430' GROUP BY GoodsID,Profit ORDER BY Profit
结果是这样子的:这个语句要怎么改,才能把相同ID号的Profit加在一起呢?
比如说让原本这样的结果:
002 1.5
002 3
显示成:
002 4.5
呢?
求指导~~~~~~~~~~~~~~~~~~~~~~~~~
FROM GoodsSellVolumnbyDay
WHERE DateDay ='20130430'
GROUP BY GoodsID
ORDER BY Profit
SELECT GoodsID,sum(isnull(Profit,0))as Profit
FROM GoodsSellVolumnbyDay
WHERE DateDay ='20130430'
GROUP BY GoodsID ORDER BY Profit
FROM GoodsSellVolumnbyDay
WHERE DateDay ='20130430'
GROUP BY GoodsID
ORDER BY Profit
SELECT GoodsID,sum(isnull(Profit,0))as Profit FROM GoodsSellVolumnbyDay WHERE DateDay ='20130430' GROUP BY GoodsID ORDER BY Profit code]
SELECT GoodsID,sum(isnull(Profit,0))as Profit FROM GoodsSellVolumnbyDay WHERE DateDay ='20130430' GROUP BY GoodsID ORDER BY Profit
select GoodsID,
sum(Profit) 'Profit'
from (SELECT GoodsID,Profit
FROM GoodsSellVolumnbyDay
WHERE DateDay ='20130430'
GROUP BY GoodsID,Profit) t
group by GoodsID