分页SQL模板

select  *  from ( select rownum as rn ,a.* from ( select
*	from page a  where object_id >1000 and owner='SYS'
order by object_id desc )a where rownum<=40 ) a  where rn>=21

posted @ 2014-03-01 19:53  czcb  阅读(97)  评论(0编辑  收藏  举报