select * from (
select tb_test.*, rownum as my_rownum from (select tb_test.* from tb_test where FLD_TYPE='公文')
where rownum <120
) where my_rownum>=100
select tb_test.*, rownum as my_rownum from (select tb_test.* from tb_test where FLD_TYPE='公文')
where rownum <120
) where my_rownum>=100
select t.*, rownum as my_rownum from (select tb_test.* from tb_test where FLD_TYPE='公文') t
where rownum <120
) where my_rownum>=100
select * from (
select t.*, rownum as my_rownum from (select tb_test.* from tb_test where FLD_TYPE='公文') t
where rownum <120
) t1 where my_rownum>=100