oracle中如果对rownum使用了大于号(>),则查询的结果集一定是空的
在页面时,可采用下列方式达到>的效果
Select * from (select a.*, rownum rn from (select * from table1 t order by col1) where rownum <= 20) where rn > 10;
在页面时,可采用下列方式达到>的效果
Select * from (select a.*, rownum rn from (select * from table1 t order by col1) where rownum <= 20) where rn > 10;