Question

sql中 select sum(A),sum(B),sum(A)+sum(B) from tableA怎么写？

sql中 select sum(A),sum(B),sum(A)+sum(B) from tableA怎么写？ 我的意思是查询A列的总和，B列的总和，再把总 和A 和 总和B 相加

Answer 1

如果要 三列 A B C c列是 A+B的和 那么select sum(a) as A列,sum(b) as B 列,sum(a)+sum(b) as C列 from tablea 如果要 单列 ab的和 只需select sum(a)+sum(b) as 总和 from tablea 如果想要涉及变量 那就declare @sum int select @sum = sum(a)+sum(b) from tablea select sum(a),sum(b),@sum from tablea 就可以了
求采纳

Answer 2

select sum(A) as A总和,sum(B) as B总和,(sum(A)+sum(B)) as AB总和 from tableA