whoamiaaaa 发表于 2013-1-29 15:22:30

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。起始行数
页: [1]
查看完整版本: oracle分页语句