1)查询第90到100条
SELECT * from (SELECT z.aac001,rownum numbers from ac01 z where rownum<101) x where x.numbers>90 ;
91
92
.
100
2).用分析函数吧 (10g)
select X.*
from
(
select
row_number() over(order by aac001) as ROW_NO,
ac01.*
from ac01
) X
where X.ROW_NO <= 100
and X.ROW_NO >= 10;
3)