菜鸟问题，请各位拔刀相助

[iceshape1]

select
max(decode(f1, 1, f)) as a1,
max(decode(f2, 1, f)) as a2,
max(decode(f3, 1, f)) as a3,
max(decode(f4, 1, f)) as a4,
max(decode(f5, 1, f)) as a5,
max(decode(f6, 1, f)) as a6,
max(decode(f7, 1, f)) as a7,
max(decode(f8, 1, f)) as a8,
f9
from table1
group by f9

以上的行转列sql有时会出现“非单组分组函数”错误
不知道这个错误是什么意思，请各位大虾指点
非常感谢

[enhydraboy]

select f9,max(a1),max(a2),...max(a8)
from
(
select
decode(f1, 1, f) as a1,
decode(f2, 1, f) as a2,
decode(f3, 1, f) as a3,
decode(f4, 1, f) as a4,
decode(f5, 1, f) as a5,
decode(f6, 1, f) as a6,
decode(f7, 1, f) as a7,
decode(f8, 1, f) as a8,
f9
from table1)
group by f9

[bzszp]

应该不会有这个错误
把执行情况贴出来看看

[qiyousyc]

同意enhydraboy(乱舞的浮尘)
还可以试试
select
max(decode(f1, 1, f)) as a1,
max(decode(f2, 1, f)) as a2,
max(decode(f3, 1, f)) as a3,
max(decode(f4, 1, f)) as a4,
max(decode(f5, 1, f)) as a5,
max(decode(f6, 1, f)) as a6,
max(decode(f7, 1, f)) as a7,
max(decode(f8, 1, f)) as a8,
f9
from table1
group by f9，a1,a2....

[bzszp]

我随便写了，我以前就这样用过，没有问题
SQL> select * from dept;

DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

SQL> select max(decode(deptno,10,100,20)) as d1,max(dname) as d2,loc from dept group by loc;

D1 D2 LOC
---------- -------------- -------------
20 OPERATIONS BOSTON
20 SALES CHICAGO
20 RESEARCH DALLAS
100 ACCOUNTING NEW YORK

SQL>

[zhuzhuyan]

同意“enhydraboy(乱舞的浮尘) ( ”，
但是“bzszp(SongZip) ”咋也没有错误呢？

[hdkkk]

我也觉得你的豫剧应该可以唱阿

：）