循环写数据

2007-12-05 02:57:38 138 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

TEC 高精度控温算法：实现精准升降温与恒温控制本文深入解析了TEC高精度控温算法的核心原理与工程实践。针对TEC非线性、时变的特性，算法通过智能状态机实现精准升降温与恒温控制，并详细阐述了参数整定、硬件协同及调试优化的系统性方法，为半导体激光器、PCR仪等高精度温控应用提供了一套完整的解决方案。阅读详情

读取表A的B项（int）记录，以4条数据为单位，求和之后写入表B中，求代码？
例：
表A
B
1
5
-3
2
5
3
-2
-8
写入表B后为
5
-2

...全文

从Protocol到硬件控制：揭秘高通UEFI中ABL与XBL的协作机制本文深入解析了高通UEFI架构中ABL与XBL的协作机制，重点探讨了Protocol通信在硬件控制中的关键作用。通过对比传统GPIO控制方式，揭示了Protocol架构在安全性、可维护性和灵活性方面的优势，并提供了关机充电场景的实战案例分析及调试技巧。阅读详情

shui1212

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

火星求索 2007-12-05

打赏
举报

按最后一组个数计算和

kk19840210 2007-12-05

打赏
举报



create table #a (b int)

insert into #a values(1)

insert into #a values(5)

insert into #a values(-3)

insert into #a values(2)

insert into #a values(5)

insert into #a values(3)

insert into #a values(-2)

insert into #a values(-8)



create table #b(b int)



select id=identity(int,0,1) ,b into # from #a



insert into #b 

select b=sum(b) from # group by id/4 



select * from #b





b

-----------

5

-2



(2 行受影响)

kelph 2007-12-05

打赏
举报

select identity(int,1,0) as id ,b into # from table

insert into b
select sum(b)
from #
group by id/4

drop table #

-狙击手- 2007-12-05

打赏
举报

不好意思　，我把函数参数搞错
select identity(int,0,1) as id ,b into # from tabe

kelph 2007-12-05

打赏
举报

如果最后一组不够四条了怎么处理，剩下的算一组吗？

chuifengde 2007-12-05

打赏
举报

declare @a table(a int)

insert @a select 1 

union all select 5 

union all select -3 

union all select 2 

union all select 5 

union all select 3 

union all select -2 

union all select -8 



declare @b table(id int identity(0,1),a int)

insert @b select * from @a



select sum(a) from @b group by id/4

--result

/*

----------- 

5

-2



（所影响的行数为 2 行）*/

dawugui 2007-12-05

打赏
举报

create table A(B int)

insert into A values(1) 

insert into A values(5) 

insert into A values(-3) 

insert into A values(2) 

insert into A values(5) 

insert into A values(3) 

insert into A values(-2) 

insert into A values(-8)

create table B(B int)

go



select B , id = identity(int,0,1) into tmp from A



insert into B select 结果 from (select id = id/4 , 结果 = sum(B) from tmp group by id/4) t



select * from B



drop table A,B,tmp



/*

B           

----------- 

5

-2



（所影响的行数为 2 行）

*/

dawugui 2007-12-05

打赏
举报

create table A(B int)

insert into A values(1) 

insert into A values(5) 

insert into A values(-3) 

insert into A values(2) 

insert into A values(5) 

insert into A values(3) 

insert into A values(-2) 

insert into A values(-8)

go

select B , id = identity(int,0,1) into tmp from A



select id/4 , 结果 = sum(B) from tmp group by id/4



drop table A,tmp



/*

            结果          

----------- ----------- 

0           5

1           -2



（所影响的行数为 2 行）



*/

-狙击手- 2007-12-05

打赏
举报

select identity(int,1,0) as id ,b into # from tabe

insert into b
select id,sum(b)
from #
group by id

drop table #

循环写数据

相关推荐