oracle分页sql语句 - 阳光总在风雨后001

oracle分页sql语句

SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A

WHERE ROWNUM <= pageNum*pageSize) WHERE RN >(pageNum-1)*pageSize

pagenum第几页 pageSize页面显示页数大小，pageNum-1