降序排序,跳过前面20条开始取数据
SELECT TOP (10) --每页显示多少条
[Extent1].[UserId] AS [UserId],[Extent1].[UserName] AS [UserName]
FROM ( SELECT [Extent1].[UserId] AS [UserId], [Extent1].[UserName] AS [UserName], row_number() OVER (ORDER BY [Extent1].[UserId] DESC) AS [row_number]
FROM [dbo].[Users] AS [Extent1]
) AS [Extent1]
WHERE [Extent1].[row_number] > 20
ORDER BY [Extent1].[UserId] DESC