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千万条数据表中测试过。