oracle 分页 where 三层
标签：log pre acl class tar 结果 from star row
oracle 分页 where 三层
* FROM
(SELECT A.*, rownum rn
FROM
(SELECT * FROM tableName
ORDER BY time DESC
) A
WHERE rownum <= start + limit
) B
WHERE rn >= start;