玉祥平台客服-15087858732
标题:
Oracle 分页算法两则
[打印本页]
作者:
caixuqad
时间:
2020-6-28 18:05
标题:
Oracle 分页算法两则
-- Oracle 分页算法一
select
*
from
(
select
page.*,rownum rn
from
(
select
*
from
help) page
-- 20 = (currentPage-1) * pageSize + pageSize
where
rownum <= 20
)
-- 10 = (currentPage-1) * pageSize
where
rn > 10;
-- Oralce 分页算法二
-- 20 = (currentPage-1) * pageSize + pageSize
select
*
from
help
where
rownum<=20
minus
-- 10 = (currentPage-1) * pageSize
select
*
from
help
where
rownum<=10;
作者:
caixuqad
时间:
2020-6-28 18:06
作者:
fteair
时间:
2020-6-30 14:12
作者:
caixuqad
时间:
2020-6-30 19:15
欢迎光临 玉祥平台客服-15087858732 (http://bbs.delit.cn/)
Powered by Discuz! X3.2
