Select StockCode,max(StockName) as 'StockName',StockTime,sum(Money) as 'Money',sum(BMoney) as 'BMoney',
sum(SMoney) as 'SMoney',count(BsnsDpt) as 'BsnsDptCount',sum(StockZpb) as 'StockZpb',
max(HRange) as 'HRange' From [cycs].[dbo].[Jgxw]
group by StockTime,StockCode having StockTime>='2011-09-30' and StockTime<='2011-10-11'这个是我写的,不对的
我想要的是在StockTime这个时间段里面StockCode相同的某些字段的值就相加,group by 里不要 StockTime该怎么写
sum(SMoney) as 'SMoney',count(BsnsDpt) as 'BsnsDptCount',sum(StockZpb) as 'StockZpb',
max(HRange) as 'HRange' From [cycs].[dbo].[Jgxw]
group by StockTime,StockCode having StockTime>='2011-09-30' and StockTime<='2011-10-11'这个是我写的,不对的
我想要的是在StockTime这个时间段里面StockCode相同的某些字段的值就相加,group by 里不要 StockTime该怎么写
--不会就是这样吧?Select StockCode,max(StockName) as 'StockName',sum(Money) as 'Money',sum(BMoney) as 'BMoney',
sum(SMoney) as 'SMoney',count(BsnsDpt) as 'BsnsDptCount',sum(StockZpb) as 'StockZpb',
max(HRange) as 'HRange' From [cycs].[dbo].[Jgxw]
group by StockCode having StockTime>='2011-09-30' and StockTime<='2011-10-11'
sum(SMoney) as 'SMoney',count(BsnsDpt) as 'BsnsDptCount',sum(StockZpb) as 'StockZpb',
max(HRange) as 'HRange' From [cycs].[dbo].[Jgxw]
where StockTime between '2011-09-30' and '2011-10-11'
group by StockCode
sum(SMoney) as 'SMoney',count(BsnsDpt) as 'BsnsDptCount',sum(StockZpb) as 'StockZpb',
max(HRange) as 'HRange' From [cycs].[dbo].[Jgxw]
where StockTime>='2011-09-30' and StockTime<='2011-10-11'
group by StockCode
--这样?
Select
StockCode,max(StockName) as 'StockName',sum(Money) as 'Money',sum(BMoney) as 'BMoney',
sum(SMoney) as 'SMoney',count(BsnsDpt) as 'BsnsDptCount',sum(StockZpb) as 'StockZpb',
max(HRange) as 'HRange'
From
[cycs].[dbo].[Jgxw]
where
StockTime>='2011-09-30' and StockTime<='2011-10-11'
group by
StockCode