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
下面是 一条通用的分页代码
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 < ? ";
