能做吗？

[kanwell]

两个字段A,B
A B

1 100
1 100
1 100
2 100
2 500
3 500
3 100
X 10
X 10
如何一次将字段A中相同值求
1 300
2 1000
3 600
x 20

[txlicenhe]

Select A,sum(B) as B from 表 group by A

[pengdali]

select A,sum(B) B from 表 group by A

[lvltt]

Select A,sum(B) as B from 表 group by A

[kanwell]

谢谢各位

[kanwell]

谢谢各位