凉水代码

Code Cold Water

导航

Oracle 排序+分页

Posted on 2011-09-01 00:19  凉水代码  阅读(248)  评论(0)    收藏  举报

原sql

select * from tableA order by col desc

分页sql:

select * from (select tmp_.* rownum rn_ from (select * from tableA order by col desc)) where rn_>=1 and rn_<11