SQL>connect scott/tiger;
SQL> select max(v1) from (select avg(empno) as v1 from emp group by empno); MAX(V1)
----------
7934语句没问题~ 可能在你的 select 里的值有误(类型).
SQL> select max(v1) from (select avg(empno) as v1 from emp group by empno); MAX(V1)
----------
7934语句没问题~ 可能在你的 select 里的值有误(类型).
select max(v1) from (select avg(row2) as v1 from table group by row2 );
都可以通过吧。