Question

sql中同一字段的数值相加查询语句怎么写

比如有表table中有
A C
1 20
1 30
2 40
3 55
3 12
4 66

如果要根据A 来选择所有相同的A对应的C 的数值合
得到
1 50
2 40
3 67
4 66

Answer 1

select A,sum(C) from t3 group by A;

Answer 2

select SUM(C) from 表名 group by A;

Answer 3

select A,sum(A) from table_name group by A

Answer 4

select a, sum(c) from 表名 group by a order by a;
这样就可以了

Answer 5

select sum(c.值) group by a.值。看这样能不能满足你的需求。