你可以写成这种的.参照一下:
SQL> select * from dd;A B C D EE
---------- ---------- ---------- ---------- ----------
A B C D 2
A B E F 3
C D G H 4
A C E F 5SQL> SELECT a,SUM(decode(a,'A',ee,1)) FROM dd GROUP BY a;A SUM(DECODE(A,'A',EE,1))
---------- -----------------------
A 10
C 1SQL> SELECT a,SUM(decode(a,'A',ee,1))/1 FROM dd GROUP BY a;A SUM(DECODE(A,'A',EE,1))/1
---------- -------------------------
A 10
C 1SQL>
SQL> select * from dd;A B C D EE
---------- ---------- ---------- ---------- ----------
A B C D 2
A B E F 3
C D G H 4
A C E F 5SQL> SELECT a,SUM(decode(a,'A',ee,1)) FROM dd GROUP BY a;A SUM(DECODE(A,'A',EE,1))
---------- -----------------------
A 10
C 1SQL> SELECT a,SUM(decode(a,'A',ee,1))/1 FROM dd GROUP BY a;A SUM(DECODE(A,'A',EE,1))/1
---------- -------------------------
A 10
C 1SQL>
你遇到的问题好像跟这个无关
sum(),至于sql语句对不对可以再验证。
如果你要判断‘字段1’而且还必须是group by a.mc,a.dw,b.NY,那就要用到sum(decode(字段1,,))的方法,而不能用decode(字段1,,sum())。
请帮帮忙吧,我好急
round(sum(decode(字段1,'000',字段3,0))/日历天数)