Posted on 2007-07-23 08:47
semovy 阅读(276)
评论(0) 编辑 收藏 所属分类:
数据库方面
select * from
(
select top(pagesize) * from
(
select top (pagesize * pageindex) *
from articles
order by id desc
)
order by id asc
)
order by id desc
oracle:
select * from (
select rownum num,t1.*
from table t1 where fast=0
) where num>=intposition and num<=intendposition