① 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