代码改变世界

sql2005的新分页

2012-08-02 16:19  hongjiumu  阅读(147)  评论(0编辑  收藏  举报

不用not in 的分页:

SELECT * FROM

(
SELECT TOP 3 ROW_NUMBER() OVER(ORDER BY [t0].[CreateTime] DESC) RN,* FROM [Pro_AttributeType] AS [t0]

WHERE ([t0].[DeleteFlag] = 0) ) [t0]

WHERE RN>2