高效的分页语句

select *
  from (select row_.*, rownum rownum_
          from (select * from b_ldzc where txm like '%36%') row_
         where rownum <= 40)
 where rownum_ >= 10

 

三层嵌套可以高效查询出分页结果