sql2008中用到的
性能比较好,测试过150万行的表,平均查询时间约为3-4秒
DECLARE @Start INT
DECLARE @End INT
SELECT @Start = 0,@End = 50
SELECT *
FROM (
select *,ROW_NUMBER() OVER (ORDER BY B_User.Add_Time desc) AS RowNumber from B_User ) QueryPage
WHERE RowNumber > @Start AND RowNumber <= @End
ORDER BY B_User.Update_Time desc