可以使用，需要在套一层变成from后面的内联视图。比如select * from dept a where a.deptno in (select depton from ( select b.deptno from dept b order by b.dname ) [where rownum < 5])
