minus 与 order

[zenghongmei1]

使用minus时不能用order by 排序？

select c1 from t1 where rownum<10 order by c1
minus
select c1 from t1 where rownum<5 order by c1

出错。

[jiezhi]

select xm from (select xm from t_ygjbxx where rownum<10 order by xm)
minus
select xm from (select xm from t_ygjbxx where rownum<5 order by xm)

[hdkkk]

SELECT C1 FROM (SELECT C1 FROM T1 WHERE ROWNUM<10 MINUS SELECT C1 FROM T1 WHERE ROWNUM<5) ORDER BY C1;

[zcs_1]

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;

[zhaoyongzhu]

select c1 from
(select c1 from t1 where rownum<10
minus
select c1 from t1 where rownum<5)
order by c1

[yuxuan]

用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;