sqlserver分页(二)sqlserver2005千万级分页查询

在sqlserver2005下使用下面语句
WITH t AS (
                    SELECT ROW_NUMBER() OVER(ORDER BY id DESC) as row_number, id,ss
                    from Table4
                 )
Select ROW_NUMBER() OVER(ORDER BY id DESC) as row_number1,id,ss
from t
where row_number BETWEEN 11000011 and 11010020
 sqlserver2000不支持该写法，该写法1千万条数据表中测试过。