select rownum from orderTable where rownum between 1 and 200 ;
可以选择出行,
select rownum from orderTable where rownum between 100 and 200 ;
未选定行,能说一下为什么吗???
可以选择出行,
select rownum from orderTable where rownum between 100 and 200 ;
未选定行,能说一下为什么吗???
select rownum rn from orderTable where rownum<=200)
where rn>=100
(select rownum num from orderTable where rownum between 1 and 200) t where t.num>100
select * from (select rownum from orderTable) as a where rownum between 1 and 200
SELECT NO, NAME,
ROW_NUMBER() OVER (ORDER BY NO) RNUM
FROM ROWNUM_TEST
) WHERE RNUM BETWEEN 5 AND 10
select * from (
select a.*,rownum num from (
select * from 表名 order by 列名 desc
) a where rownum<=20
) where num>=10;ORDERY BY应该这样使用哦~
蓝色的地方是以后用于传参数的地方,你可以把分页封装成一个JAVABEAN,传入原始SQL和需要获取的起始位置,这样的话应该可以提高代码的复用性吧。
我刚刚开始学ORACLE,不怎么会,有误的地方还请大师们多多指点,谢谢了。