Oracle数据库分页查询
//把数据添加序号
SELECT * FROM (SELECT g.*,ROWNUM RN FROM (SELECT * FROM gongHuoShang) g)
分页sql语句
//pageSize 每页显示的条数
//pageCode 页数
SELECT * FROM (SELECT g.*,ROWNUM RN FROM (SELECT * FROM gongHuoShang) g) WHERE RN > pageSize*(pageCode-1) AND RN <= pageCode*pageSize;
或
//pageSize 每页显示的条数
//pageCode 页数
SELECT * FROM (SELECT g.*,ROWNUM RN FROM gongHuoShang g) WHERE RN > pageSize*(pageCode-1) AND RN <= pageCode*pageSize;