select B.*
from (select A.*, rownum r from b_gl_yh_shuihsscb A ORDER BY A.JIHZDBH) B
from (select A.*, rownum r from b_gl_yh_shuihsscb A ORDER BY A.JIHZDBH) B
where B.r between 6 and 10;
select B.*
from (select t.*,rownum r from
(select * from b_Jh_Touzjh a where exists (select b.jhxm from B_JH_DILXX_F b where b.jhxm = a.jhxm) order by a.recid)
t) B
where B.r between 2 and 5;