oracle分页查询SQL文:
***********************************************************
******************author:lenkou*************************
***********************************************************
第一种(效率低):
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM TABLE_NAME A
)
WHERE RN BETWEEN numFrom AND numTo
第二种(效率高):
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM TABLE_NAME A
WHERE ROWNUM <= numTo
)
WHERE RN >= numFrom
创建表并插入数据:
CREATE TABLE T AS SELECT * FROM TABLE_NAME;