① sql月份累計
sql語句為：update表set日期欄位=dateadd(m,1,日期欄位)定義和用法DATEADD()函數在日期中添加或減去指定的時間間隔。語法DATEADD(datepart,number,date)date參數是合法的日期表達式。number是您希望添加的間隔數；對於未來的時間，此數是正數，對於過去的時間，此數是負數。
② sql怎麼寫每個商品，每個月的銷售額求和
select CONVERT(char(6), txdate, 112) txdate,sum(trans) trans from 表名 group by CONVERT(char(6), txdate, 112)
ID肯定是不能加了
③ sql如何實現 連續12個月對應數據求和
select
sum(case when Year(時間)=2014 then 統計列 else 0 end ) as 1-12月,
sum(case when Month(時間)=1 then 統計列 else 0 end ) as 1月,
sum(case when Month(時間)=1 or Month(時間)=2 then 統計列 else 0 end ) as 1-2月,
....
from 表
④ SQL 庫存明細賬月份累計與合計
如果三樓可以的話你可以這樣做：
select rq,sl,je from kc where datepart(month,rq)=10 and datepart(year,rq)=2008
union all
select '10月累計',sum(sl),sum(je)from kc where datepart(month,rq)=10 and datepart(year,rq)=2008
union all
select '10月合計',sum(sl),sum(je)from kc where datepart(month,rq)<=10 and datepart(year,rq)=2008
union all
select rq,sl,je from kc where datepart(month,rq)=11 and datepart(year,rq)=2008
union all
select '11月累計',sum(sl),sum(je)from kc where datepart(month,rq)=11 and datepart(year,rq)=2008
union all
select '11月合計',sum(sl),sum(je)from kc where datepart(month,rq)<=11 and datepart(year,rq)=2008
union all
select rq,sl,je from kc where datepart(month,rq)=12 and datepart(year,rq)=2008
union all
select '12月累計',sum(sl),sum(je)from kc where datepart(month,rq)=12 and datepart(year,rq)=2008
union all
select '12月合計',sum(sl),sum(je)from kc where datepart(month,rq)<=12 and datepart(year,rq)=2008
⑤ SQL按月份累計求和
用自定義函數
create FUNCTION getsum(@月份 int)
RETURNS int
AS
begin
declare @sum int
select @sum=sum(個數) from 表名 where 月份<=@月份
return @sum
end
然後查詢
select 月份,dbo.getsum(月份) as 個數 from 表名
⑥ sql按月求和語句怎麼寫
使用 case when 配合 sum來統計。
如圖表a2
⑦ sql循環求和 條件：月份+3=當前月
--樓主並沒有說清楚查詢條件，所以如下只是猜測：
select SUM(isnull(intA,0)) as 合計
from 表1 where Month(AddDate(Month,3,Date1))=Month(GetDate())
--對月份加上3得到的月份數等於當前系統日期的月份數 的記錄集合中的 intA求和
比如說當前日期是 2015.5.20，那麼Month(GetDate())就是5;
所以只有Date1的月份是2的才會查出來並合計，這種是沒有考慮年的，如果要考慮年的，做條件就不是這樣的。
⑧ sql怎麼將當月每一天的數據相加，求總和
insertintobartext(time,electricity)VALUES('2/2/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/3/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/4/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/5/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/6/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/7/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/8/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/9/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/10/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/11/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/12/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/13/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/14/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/15/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/16/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/17/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/18/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/19/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/20/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/21/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/22/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/23/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/24/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/25/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/26/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/27/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('2/28/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/1/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/2/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/3/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/4/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/5/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/6/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/7/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/8/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/9/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/10/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/11/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/12/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/13/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/14/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/15/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/16/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/17/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/18/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/19/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/20/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/21/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/22/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/23/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/24/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/25/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/26/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/27/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/28/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/29/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/30/2019',cast(floor(rand()*150)asint))
insertintobartext(time,electricity)VALUES('3/31/2019',cast(floor(rand()*150)asint))
⑨ SQL 累計遞增求和
createviewvw_withsummaryas
selectid,data
,(selectsum(data)
fromthetableb
whereb.id<=a.id
)assummary
fromthetablea