Oracle 高效分页

 

 

(
     select t.rid from (select rowid rid ,rownum rn from  YJJBNTBHQ_2017 where rownum<100000 ) t where t.rn>99990
)
select  t1.GEOMETRY.Get_WKT(),t1. BHQBH,t1.GDMJ,t1.YSDM,t1.BHJSSJ,t1.BHKSSJ,t1.BSM,t1.JBNTMJ,t1.BHQMJ,t1.ZLDJDM from YJJBNTBHQ_2017 t1 where rowid in(select rid from t) and rownum<10;

 

上一篇:SQL SERVER 类似 Orcal中的rowid


下一篇:jqGrid常用操作