SELECT
*
FROM
(
SELECT
temp.*, ROWNUM RN
FROM
(
SELECT
*
FROM
(SELECT * FROM 表名)
ORDER BY
ORDER DESC
) temp
WHERE
ROWNUM <=
END (page * pagesize)
)
WHERE
RN >= START (page - 1 * pagesize + 1)
分页查询不排序
SELECT
*
FROM
(
SELECT
temp.*, ROWNUM RN
FROM
(SELECT * FROM 表名) temp
WHERE
ROWNUM <=
END (page * pagesize)
)
WHERE
RN >= START (page - 1 * pagesize + 1)
主键自增 1 首先创建一个序列
CREATE SEQUENCE "用户名"."序列名"
MINVALUE MIN ##最小值
MAXVALUE MAX ##最大值
INCREMENT BY 1 ##步长
START WITH 1 CACHE 20 NOORDER NOCYCLE