oracle 分页

记录一下，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

下面是 一条通用的分页代码

String sql = "select rownum as row_num,t__.* from (" + innerSql+ ") t__";sql = "select X_.* from(" + sql + ") X_ where "+ "X_.row_num>=? and X_.row_num < ? ";