56,677
社区成员
发帖
与我相关
我的任务
分享
update temp set data=(select sum(data) from temp where data is not null) where id=10;
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([id] int,[name] nvarchar(22),[data] int)
Insert #T
select 0,N'河北',50468 union all
select 1,N'江西',71429 union all
select 2,N'山东',69591 union all
select 3,N'宁夏',48825 union all
select 4,N'甘肃',96813 union all
select 5,N'贵州',55565 union all
select 6,N'湖北',72192 union all
select 7,N'湖南',90473 union all
select 8,N'广西',99914 union all
select 9,N'四川',91375 union all
select 10,N'全国',null
Go
--测试数据结束
UPDATE #T SET data=(SELECT SUM(data) FROM #T WHERE id BETWEEN 0 AND 9) WHERE id=10
SELECT * FROM #T