Oracle分页

最新推荐文章于 2025-08-13 17:52:41 发布

tomato你个番茄

最新推荐文章于 2025-08-13 17:52:41 发布

阅读量142

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle 文章标签：数据库

本文链接：https://blog.youkuaiyun.com/QSpace/article/details/84050266

oracle 专栏收录该内容

2 篇文章

订阅专栏



根据开始位置和结束位置分
select * from

(select a.*,rownum row_num from

(select * from mytable t order by t.id desc) a

) b where b.row_num between 1 and 10

根据当前页和每页最大数分
SELECT TWO.* FROM
		(SELECT ROWNUM RN, ONE.* FROM (
		SELECT * FROM empl
		) ONE) TWO
		WHERE 1 = 1
		AND TWO.RN > 10 * (2 - 1)
		AND TWO.RN < 10 * 2 + 1