SQL分页及排重

最新推荐文章于 2022-09-27 22:59:29 发布

weixin_30767921

最新推荐文章于 2022-09-27 22:59:29 发布

阅读量163

点赞数

原文链接：http://www.cnblogs.com/haver/archive/2011/08/18/2144974.html

版权

declare @page int=3;
declare @perpage int=20;

SELECT UserID, PostTime, rid FROM (
    SELECT UserID, PostTime, rid=ROW_NUMBER() OVER(ORDER BY PostTime) FROM (
        SELECT UserID,PostTime,rowid=ROW_NUMBER() OVER(PARTITION BY UserID ORDER BY PostTime DESC)
            FROM Activity..OnlineMatch2th
            WHERE PostDate='2011-8-11'
    )t WHERE rowid=1
)t2 WHERE rid BETWEEN (@page-1)*@perpage+1 AND @page*@perpage

转载于:https://www.cnblogs.com/haver/archive/2011/08/18/2144974.html