Oracle 分页sql实现
分页sql
-- 返回 (第一页) 1-5行数据 SELECT * FROM ( SELECT ROWNUM AS rowno, t.* FROM CMS_ARTICLE t WHERE ROWNUM <= 5 ) table_alias WHERE table_alias.rowno >= 1;
内容仅供参考,并非百分百解决您的问题。
分页sql
-- 返回 (第一页) 1-5行数据 SELECT * FROM ( SELECT ROWNUM AS rowno, t.* FROM CMS_ARTICLE t WHERE ROWNUM <= 5 ) table_alias WHERE table_alias.rowno >= 1;