Oracle, SQL Server 和MySQL的分页SQL语句如下:
oracle:方法1
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= 40
)
Oracle, SQL Server 和MySQL的分页SQL语句如下:
oracle:方法1
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= 40
)