jdbc分页

-------------------------------------------------sql------------------------------------------

 

select ip,bwsign,updatetime,reason,num from (select rownum rn,ip,bwsign,updatetime,reason,num from (select /*+ use_hash(a,b) */ ip,bwsign,updatetime,reason,count(tk3) num from mst_iplist_tbl a,(select tk3 from ttl_user_tbl where lockendtime>sysdate) b where a.ip=b.tk3(+) and a.bwsign in ('B','E','F','H','G','Y')  group by ip,bwsign,updatetime,reason) where rownum<=?) where rn>=?

 

 

 

rownum 为结束条数

 

rn 为要查询的开始条数 即第几条