select * from
( select a.* , rownum row_num from
( select 字段
from 表
where 条件
)a
)b
where b.row_num between START_NUM and END_NUM
select * from
( select a.* , rownum row_num from
( select 字段
from 表
where 条件
)a
)b
where b.row_num between START_NUM and END_NUM