SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM (此处添加你要分页的表)) A
WHERE ROWNUM <= 14000
)
WHERE RN >= 1
数字代表你显示的行数，简单易用的语句
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM (此处添加你要分页的表)) A
WHERE ROWNUM <= 14000
)
WHERE RN >= 1
数字代表你显示的行数，简单易用的语句