Find the sum of the SQL statements

fireacer

The table is as follows
A 20
B 10
A 5
B 10
A 30

The query is required to produce the following results, how to write the sentence:
A 55
B 20

unkmass

select A,sum (field 2) from table group by A

unkmass

select field 1, sum(isnull(field 2, 0)) from table group by field 1

cv4bf5d65fd

select c1,sum(c2) field 2
from tablename
group by c1

fanfan1980

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

hiqwolfzzh

select field 1, sum (field 2)
from table
group by A

hiqwolfzzh

select field 1, sum(isnull (field 2, 0)
from table
group by field 1