现在sql可以查出数据，但我要求出三列的和，就是一列一个求和

Question

SELECT 
  A.*
  FROM     IF02 A
 WHERE a.aae100 = aae100
   and a.aab004s = aab004s
   and a.aab005s = aab005s
   and a.aaz030 = aaz030
   and a.aab999 = aab999
   and a.aab004 = aab004
   and a.ifa032=ifa032
   and a.ifa031=ifa032

sql，写好了，但是我要ifa031,ifa032,aab004s 这三列的求和
我该在这个上面怎么改？

Answer 1

用sum

SELECT 
  sum(a.ifa031) as '你想要的列名',
  sum(a.ifa032) as '你想要的列名',
  sum(a.aab004s) as '你想要的列名'
  FROM     IF02 A
 WHERE a.aae100 = aae100
   and a.aab004s = aab004s
   and a.aab005s = aab005s
   and a.aaz030 = aaz030
   and a.aab999 = aab999
   and a.aab004 = aab004
   and a.ifa032=ifa032
   and a.ifa031=ifa03