准备数据:
create table TEST_001 nologging as select rownum x from dual connect by level <= 1000;
any(),all()说明:
--any
select * from TEST_001 t where t.x > any(800,900,950);
--大于号:大于any括号里面的最小值
select *
准备数据:
create table TEST_001 nologging as select rownum x from dual connect by level <= 1000;
any(),all()说明:
--any
select * from TEST_001 t where t.x > any(800,900,950);
--大于号:大于any括号里面的最小值
select *