oracle分页sql

SELECT *
FROM (
	SELECT *
	FROM (
		SELECT row_number() OVER (ORDER BY t1.OBJECTID) AS sort, t1.*
		FROM T_SJCZRZ t1
		WHERE t1.OBJECTID BETWEEN 100 AND 600
	) t2
	WHERE t2.sort < 10 * 2
)  where sort > 10*(2-1);

参考https://www.cnblogs.com/jay763190097/p/6813792.html

结果：