SELECT TOP {0} * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY UpdatedDate desc) AS RowNumber,* FROM [表名] Where (1=1) and (其他条件)
) A WHERE RowNumber > {0}*({1}-1)
{0}：PageSize每页条数
{1}：PageIndex当前页码(1开始)
原文：http://www.cnblogs.com/liaoshiqi/p/7447128.html