WITH MOVIES
AS (
SELECT ROW_NUMBER()
OVER (
ORDER BY uid
desc)
AS Row,
* FROM ValorUser
WHERE UserType
=1
)
SELECT * FROM MOVIES
WHERE Row
between (
@PageIndex-1)
* @PageSize+1 and @PageIndex*@PageSize
ORDER BY [uid] DESC
WITH MOVIES
AS (
SELECT ROW_NUMBER()
OVER (
ORDER BY uid
desc)
AS Row,
* FROM ValorUser
WHERE UserType
=1
)
SELECT * FROM MOVIES
WHERE Row
between 1 and 20
ORDER BY [uid] DESC
转载于:https://www.cnblogs.com/wugang/archive/2012/08/07/2626414.html
