1、select * from ( select rownum as IdRow,a.* from emp a) where IdRow=10 或则: select * from emp where rownum<=10 minus select * from emp where rownum<=9
2、select * from emp where rownum<=7 minus select * from emp where rownum<=4 其实还有其他方式的! [解决办法] select * from emp where rownum =10; select e.* from (select * from emp where rownum=7) e where rownum >=5; PS:oraclec查询列的时候只能从头开始或者从后面开始,不能在中间选择。 PS:菜鸟一枚,一起探讨。不知道有没有忘记。。