求一求和的sql语句

[wei_gogo]

我的记录如下：
a 1
b 2
b 3
a 4
c 1
c 1
想得到
a 5
b 5
c 2
就是把相同类型数值求和,谢谢

[yesterday2000]

select col1,sum(col2) as col2 from tb
group by col1

[Andy__Huang]

select col1,col2=sum(col2) from tb group by col1

[wei_gogo]

糟糕
我是在access，是不是不行哦
我开始也是这样写的

[Andy__Huang]

應該沒問題

[wenhongL]

ACCESS2000:
SELECT [tb1].[col1], Sum([tb1].[col2]) AS col2
FROM tb1
GROUP BY [tb1].[col1];

[wei_gogo]

hdhai9451(※★開拓者...前進☆※)
要你试了才知道

[wei_gogo]

搞定了，的确是这个句子，不过刚才我没有选择好，结帐

[long111]

create table t(name1 char(4),value int)
insert into t
select 'a','1' union all
select 'b','2' union all
select 'b','3' union all
select 'a','4' union all
select 'c','1' union all
select 'c','1'
go

select name1,sum(value)
from t
group by name1

drop table t