81,091
社区成员
发帖
与我相关
我的任务
分享
select sum(column2) from table1 group by column1
SQL> select * from t;
A B
---------- ---------------------------------------
aaaa 1
bbbb 2
aaaa 5
bbbb 3
SQL> select a,sum(b) b from t group by a;
A B
---------- ----------
aaaa 6
bbbb 5