select *
from (select row_.*, rownum rownum_
from (select * from b_ldzc where txm like '%36%') row_
where rownum <= 40)
where rownum_ >= 10
三层嵌套可以高效查询出分页结果
select *
from (select row_.*, rownum rownum_
from (select * from b_ldzc where txm like '%36%') row_
where rownum <= 40)
where rownum_ >= 10
三层嵌套可以高效查询出分页结果