select * from tableName limit (pageNo-1)*pageSize,pageSize
Oracle语句
//sql就是你要查询的sql语句//需要双循环的原因是查询的sql可能经过排序,不是按rownum排序的,如果没有经过排序可以省略一层循环"select * from (select row_.*,rownum rownum_ from ("+sql+") row_ where rownum<=pageNo*pageSize) where rownum_>(pageNo-1)*pageSize)"
Mysql语句select * from tableName limit (pageNo-1)*pageSize,pageSizeOracle语句//sql就是你要查询的sql语句"select * from (select row_.*,rownum rownum_ from ("+sql+") row_ where rownum<=pageNo*pageSize) where rownum_>(pageNo-1)*pageSize)"...