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