赞
踩
SELECT
*
FROM
(
SELECT
ROW_NUMBER () OVER ( ORDER BY B.START_DATE DESC,B.ID) AS PagedNumber,
B.*
FROM ( your sql ) B )
WHERE
PagedNumber BETWEEN (( :PAGE_INDEX -1 ) * :PAGE_SIZE + 1 )
AND (:PAGE_INDEX * :PAGE_SIZE)
PAGE_INDEX :页码
PAGE_SIZE :页面大小
方便日后用到,记录一下,有需要的可以点赞自取
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。