oracle 分页
select * from
(select a.*,rownum row_num from
(select * from mytable t order by t.id desc) a
) b where b.row_num between 1 and 10
posted on 2011-06-20 12:08 大飞-q4444zpf 阅读(115) 评论(0) 编辑 收藏 举报
大飞的博客
select * from
(select a.*,rownum row_num from
(select * from mytable t order by t.id desc) a
) b where b.row_num between 1 and 10
posted on 2011-06-20 12:08 大飞-q4444zpf 阅读(115) 评论(0) 编辑 收藏 举报