SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A where #xxx
)
WHERE RN BETWEEN #from AND #to
解释:table_name 表名
#xxx:条件
#from 记录开始处
# to 记录结束处
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A where #xxx
)
WHERE RN BETWEEN #from AND #to
解释:table_name 表名
#xxx:条件
#from 记录开始处
# to 记录结束处