drop table  if exists test;

create table test(v1 int,v2 int,v3 int);

insert into test select level,level,level from dual connect by level<=100;

select v1 from test group by v1 order by v2;--ok

select v1,v2 from test group by v1 order by v2; --ok

但是当该参数是 0 的时候,两个目标语句,均报错

-- modify COMPATIBLE_MODE 0

select v1 from test group by v1 order by v2;--err 无效的 ORDER BY

select v1,v2 from test group by v1 order by v2; --err 不是 GROUP BY

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员