分页

来源：互联网发布：淘宝男装原单编辑：程序博客网时间：2024/06/08 11:24

Oracle分页：

SELECT *  FROM (SELECT T.*, ROWNUM R          FROM (SELECT C.SCENIC_NAME POSITION_NAME,                       B.PROVICE PRO_NAME,                       SUM(A.TOURISTSNUM) VISITORS                  FROM KEYUANFENXI A, CITY_MANAGER B, AREA_MANAGER C                 WHERE A.ACQUISITIONTIME >= TO_CHAR(SYSDATE - 7, 'YYYYMMDD')                   AND A.ACQUISITIONTIME < TO_CHAR(SYSDATE, 'YYYYMMDD')                   AND A.SCENICID = #{positionId}                   AND A.SCENICID = C.SCENICID                   AND B.CITYID = A.TRAVELERSSOURCE                   AND C.TYPE IN (1, 2, 3, 4)                 GROUP BY C.SCENIC_NAME, B.PROVICE                 ORDER BY VISITORS DESC) T         WHERE ROWNUM <= (PAGE * PAGESIZE)) WHERE R >= (PAGE - 1) * PAGESIZE

Sysbase分页：

SELECT *  FROM (SELECT RANK() OVER(ORDER BY W.WEB_ID) NUM, W.WEB_ID, W.WEB_NAME          FROM RESORT_CFG_WEB W         WHERE 1 = 1           AND W.WEB_NAME LIKE '%' || #{WEB_NAME} || '%'           AND W.WEB_ID = #{WEB_ID}) TWHERE T.NUM > (#{PAGE} - 1) * #{PAGESIZE} AND T.NUM <= (#{PAGE} * #{PAGESIZE})

0 0