Oracle分页查询

发布时间：2020-12-12 15:26:31 所属栏目：百科来源：网络整理

导读：oracle分页查询： SELECT*FROM(SELECTROWNUM AS rowno,t.*FROMtablename tWHEREhire_date BETWEEN TO_DATE ('20060501','yyyymmdd')AND TO_DATE ('20060731','yyyymmdd')AND ROWNUM = 20) table_aliasWHEREtable_alias.rowno = 10;

oracle分页查询：

SELECT
	*
FROM
	(
		SELECT
			ROWNUM AS rowno,t.*
		FROM
			tablename t
		WHERE
			hire_date BETWEEN TO_DATE ('20060501','yyyymmdd')
		AND TO_DATE ('20060731','yyyymmdd')
		AND ROWNUM <= 20
	) table_alias
WHERE
	table_alias.rowno >= 10;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!