sql中sum()求和怎么写呀？

[Bestregards]

问你下哈，我要把下面一个test表中的字段：
id materialamount
5 10
6 20
5 40
7 30
6 90
要把id相同的materialamount进行相加！
生成test1表，怎么写sql语句呀？
id materialamount
5 50
6 110
7 30

[九斤半]

select
ID,
sum(materialamount) as materialamount
from test
group by ID

[九斤半]

select
ID,
sum(materialamount) as materialamount
into test1 from test
group by ID

[dawugui]

select id ,sum(materialamount) from t group by id

[MakeToday]

select id,sum(materialamount) as materialamount into test1
from test
group by id

[Bestregards]

好的！解决了！谢谢各位哈！

[chenjunjarysky]

select id ,sum(materialamount) from t group by id

[zhangguangxue_xx]

declare @b table(id1 int,materialamount int)
insert into @b values(5,10)
insert into @b values(6,20)
insert into @b values(5,40)
insert into @b values(7,30)
insert into @b values(6,90)


select id1,sum(materialamount) from @b group by id1

结果：
5 50
6 110
7 30

[zhangguangxue_xx]

忘记加入另一个表了，下面为加上的：
declare @b table(id int,materialamount int)
insert into @b values(5,10)
insert into @b values(6,20)
insert into @b values(5,40)
insert into @b values(7,30)
insert into @b values(6,90)


select id,sum(materialamount) into test1 from @b group by id

结果：
id materialamount
5 50
6 110
7 30

到时候把@b换掉即可。

[no_mIss]

select id,sum(materialamount) from test group by id
或
select distinct id,
(select sum(materialamount) from test where id=t.id)as materialamount
from test t

[no_mIss]

解决了快给分哇,哇哈哈.