Posted on 2007-07-23 08:47
semovy 閱讀(284)
評論(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