34,838
社区成员




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 行受影响)
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 行)*/
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 行)
*/
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 行)
*/