附加在Oracle中取前10条记录的SQLselect * from(select * from table1 order by col1) where rownum <=10 java+Oracle中处理分页的方法select * from(select * from table order by col1) where rownum <= 100 order by rownum desc设置RowSet的setMaxRows(10)这样就能取出 90 到 100的记录,而不用每次都全部取出所用数据到RowSet
java+Oracle中处理分页的方法select * from(select * from table order by col1) where rownum <= 100 order by rownum desc设置RowSet的setMaxRows(10)这样就能取出 90 到 100的记录,而不用每次都全部取出所用数据到RowSet