Oracle,sql,分页处理,一句sql搞定，原创

May 31, 2006 — Secondstupid
要求按照降序排列，例子如下
oracle 没有top，所以使用隐式游标来实现分页功能
select * from (
select * from (
select * from table order by field asc)
where rownum<=:limit*:page)

minus

select * from (
select * from (
select * from table order by field asc)
where rownum<=:limit*(:page-1))

变量说明如下
:limit 显示几条
:page 显示第几页

Share
Posted in 数据库. RSS feed for comments on this post.. TrackBack URL.

Comments are closed.

«
»