数据统计问题 select date,(select sum(num) from tb where date<=a.date) from tb a 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select date,(select sum(num) from tb where date<=a.date) from tb a declare @t table(Date varchar(10), Num int)insert @t select '2008-11', 5 insert @t select '2008-10', 10 insert @t select '2008-09', 5 select date,num=(select sum(num) from @t where date<=t.date) from @t t/*date num ---------- ----------- 2008-11 202008-10 152008-09 5*/ create table #DD(Date varchar(10),Num int)insert #DD select '2008-11',5 insert #DD select '2008-10',10 insert #DD select '2008-09',5 select date,num=(select sum(num) from @t where date<=d.date) from #DD d create table #DD(Date varchar(10),Num int)insert #DD select '2008-11',5 insert #DD select '2008-10',10 insert #DD select '2008-09',5 select date,num=(select sum(num) from #DD where date<=d.date) from #DD d 求sql写法 请问SQL server中的一个定义问题 @@@@@@@@SQL语句的修改@@@@@@@@ ~~~~~关于SQL2000导回数据库的问题~~~~~ sql表对照批量替换 数据库环境怎么设置啊?? C#调用SSIS包 关于数据库备份和还原的问题!急!300分! 高手请进来解决!(高分悬赏) 我计算库存的方法对吗?请看看。 天大难题,各路高手争相失败。。。。 再一个烦人的查询
insert @t select '2008-11', 5
insert @t select '2008-10', 10
insert @t select '2008-09', 5
select date,num=(select sum(num) from @t where date<=t.date) from @t t
/*date num
---------- -----------
2008-11 20
2008-10 15
2008-09 5*/
insert #DD select '2008-11',5
insert #DD select '2008-10',10
insert #DD select '2008-09',5
select date,num=(select sum(num) from @t where date<=d.date) from #DD d
insert #DD select '2008-11',5
insert #DD select '2008-10',10
insert #DD select '2008-09',5 select date,num=(select sum(num) from #DD where date<=d.date) from #DD d