oracle分页查询语句

来源：互联网发布：单片机0xff是什么意思编辑：程序博客网时间：2024/04/29 20:35

SELECT * FROM
(
SELECT A.*, ROWNUM num
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <=10
)
WHEREnum>=1

0 0