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 这三列的求和
我该在这个上面怎么改?
用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
SELECT sum(A.ifa031),sum(A.ifa032),sum(A.aab004s) 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