sql语句写法

Question

表aaaa    1 
bbbb    2
aaaa    5
bbbb    3现在我要如下结果aaaa    6
bbbb    5请问sql语句这么写?   谢谢

Answer 1

select sum(column2) from table1 group by column1

Answer 2

不太明白你的意思   如果你是想查找  字段aaaa和字段bbbb 里值的总和  
可以用函数  SUM（）
select SUM(a), SUM(b) from 表

Answer 3

select column1,sum(column2) as kk  from table1 group by column1 order by kk

Answer 4

SQL> select * from t;A                                                B
---------- ---------------------------------------
aaaa                                             1
bbbb                                             2
aaaa                                             5
bbbb                                             3SQL> select a,sum(b) b from t group by a; A                   B
---------- ----------
aaaa                6
bbbb                5

Answer 5

select col1,sum(col2) from t group by col1 order by col1;