oracle 分页 where 三层

查询[start,start+limit],包含start，包含start+limit,如start=21,limit=10结果就是21到30，包含21和30
SELECT * FROM
  
     (SELECT A.*, rownum rn
       FROM
          (SELECT *  FROM tableName
           ORDER BY time DESC
          ) A
          WHERE rownum <= start + limit
     ) B
 
    WHERE rn >= start;