这个SQL怎么写啊。值累加(我一晚上没写出来)在线等 select identity(int,1,1) ID,a.* into #t1 from ta_test aselect name,(select sum(persent) from #t1 where ID<=a.ID) as persentfrom #t1 a 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select identity(int,1,1) id, * into #t from ta_testselect [name],(select sum(persent) from #t where id<=a.id ) persentfrom #t a select * into #temp from ta_testdeclare @a numeric(10,2)set @a=0update #temp set @a=@a+persent,persent=@aselect * from #temp select * into #temp from ta_testdeclare @a numeric(10,2)set @a=0update #temp set @a=@a+persent,persent=@aselect * from #temp SELECT name, (SELECT SUM(persent) FROM test1 a WHERE a.name <= b.name) AS addpersentFROM test1 b 这语句怎么写? 求两个时间的时间差,但要去除某一段时间,求SQL语句 简单select 问题,请指教! 行变列查询的另一种方案,大家来讨论一下可行不? 提问 怎么样用T_SQL来删除赋予库与表的权限~!? 是否有错 sqlserver2005 Analysis Service部署问题 关于sql语句的问题 操作过dbf文件上传到SQLServer的请进 行列转换问题,分不成问题 这个SQL语句怎么写?在线等待!非常谢谢.很急!!!!!!
from #t a
declare @a numeric(10,2)
set @a=0
update #temp set @a=@a+persent,persent=@a
select * from #temp
declare @a numeric(10,2)
set @a=0
update #temp set @a=@a+persent,persent=@a
select * from #temp
(SELECT SUM(persent)
FROM test1 a
WHERE a.name <= b.name) AS addpersent
FROM test1 b