sql2005的新分页

it2022-05-05  126

不用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

转载于:https://www.cnblogs.com/hongjiumu/archive/2012/08/02/2620234.html


最新回复(0)