最好的分页

select t2.prod_id, t2.prod_name, t2.ven_id
  from (select rid
          from (select rid, rownum as rn
                  from (select rowid as rid
                          from tb_prod_mas
                         where trans_cd='200'
                         order by prod_id desc)
                 where rownum <= 20)
         where rn >= 10) t1,
       tb_prod_mas t2
 where t1.rid = t2.rowid