oracle分页 mark一下

select * from (select t.*,rownum rn from 

(

主体SQL

)

t)where rn between #{offset} and #{limit}