sqlserver 分页查询 举例

1、简单的rownumber查询  select * from (SELECT    ROW_NUMBER() OVER (ORDER BY fld_Date DESC) AS RowNumber, tab_sUsedCarPriceHistory.*
FROM         tab_sUsedCarPriceHistory) as tb where tb.RowNumber>=5 and tb.RowNumber<=10

2、注意 分页是从 1 开始