sql累加问题

就是表数据如下
H1 H2
a  1
b  2
a  2
b  2
想得到的表为
H1 H2
a  3
b  4

就是把H1相同的H2值累加,得到新的表.

---

SQL code:
select H1,sum(H2)as H2 from tb group by H1

---

SQL code:
select h1,sum(h2) as H2 from tb group by h1

---

SQL code:
--> 测试数据：[tb]
if object_id('[tb]') is not null drop table [tb]
create table [tb]([H1] varchar(1),[H2] int)
insert [tb]
select 'a',1 union all
select 'b',2 union all
select 'a',2 union all
select 'b',2

select * from [tb]

select H1,sum(H2)as H2 from tb group by H1

/*
H1 H2
a 3
b 4*/

---

楼上正解

SQL code:
select h1,sum(h2) as H2 from tb group by h1

---

SQL code:
select H1,sum(H2)as H2 from tb group by H1

---

谢谢了,我对sql真的是很菜,因为编程需要用到数据库

---

网上找也