-------------------------------------------------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 为要查询的开始条数 即第几条