--oracle分页语句 用pagesize表示每页的记录数,pageindex表示当前页
--那么取出当前页的记录条数方式为
select rn,s.* from (select rownum as rn,t.* from (select * from admin) t where rownum<=pagesize*pageindex) s where rn>pagesize*(pageindex-1);
--oracle分页语句 用pagesize表示每页的记录数,pageindex表示当前页--那么取出当前页的记录条数方式为select rn,s.* from (select rownum as rn,t.* from (select * from admin) t where rownumpagesize*(pageindex-1);