Oracle sql 分页

1. 第一种

select * from (select rownum rn, t.* from table_name t where rownum <= #{endIndex )   where rn >=#{startIndex}  

2.  第二种
select * from table_name t rowid in (select rid from (select rownum rn,rid from (select rowid rid, id from table_name t order by id desc) where rownum <= #{endIndex} ) where rn >= #{startIndex} ) order by id desc