最好的分页

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

[img]http://dl.iteye.com/upload/attachment/0071/0376/9d578519-75f2-32e6-9843-2f487b2a26b8.png[/img]

[img]http://dl.iteye.com/upload/attachment/0071/0379/91d59fca-6192-348f-9b0d-7aafe9bb20fb.png[/img]