oracle分页语句SELECT T_PAGINATION_SUMMY.* FROM (SELECT ROWNUM ROWNUMBER,T_PAGINATION.*FROM (……) T_P
oracle分页语句
SELECT T_PAGINATION_SUMMY.* FROM (SELECT ROWNUM ROWNUMBER,T_PAGINATION.* FROM (……) T_PAGINATION WHERE ROWNUM <= ?) T_PAGINATION_SUMMY WHERE T_PAGINATION_SUMMY.ROWNUMBER > ?
1。终点行数
2。起始行数