凉水代码

Code Cold Water

导航

Oracle 排序+分页

Posted on 2011-09-01 00:19  凉水代码  阅读(237)  评论(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