分页数据

http://www.cnblogs.com/wangyong/p/3396333.html

select * from(select a.*,ROWNUM rn from(sql) a where ROWNUM<=(firstIndex+pageSize)) where rn>firstIndex