select * from tableName limit 参数1,参数2
select * from
(
select * t.*,Rownum rn from(select * from tableName) t
where rn <=参数2
)
where rn >=参数1
select * from
(
select t.*, Rownum rn
from (select * from tableName) t
) where rn between 参数1 and 参数2
Oracle第一条记录为1