SELECT C1 FROM (SELECT C1 FROM T1 WHERE ROWNUM<10 MINUS SELECT C1 FROM T1 WHERE ROWNUM<5) ORDER BY C1;
select c1 from (select c1 from t1 order by c1) where rownum<10 minus select c1 from (select c1 from t1 order by c1) where rownum<5;
select c1 from (select c1 from t1 where rownum<10 minus select c1 from t1 where rownum<5) order by c1
用rownum时不支持排序的,可以这样写: select c1 from (select c1 from t1 order by c1) where rownum<10 minus select c1 from (select c1 from t1 order by c1) where rownum<5;
minus
select c1 from (select c1 from t1 order by c1) where rownum<5;
(select c1 from t1 where rownum<10
minus
select c1 from t1 where rownum<5)
order by c1
select c1 from (select c1 from t1 order by c1) where rownum<10
minus
select c1 from (select c1 from t1 order by c1) where rownum<5;