来源:Sql Server分页分段查询百万级数据四种项目实例 - 浪礁 - 博客园
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY id ASC) AS rowid,* FROM [DBName].[dbo].[tabName]
) t
WHERE t.rowid > 100000 AND t.rowid <= 100050;
来源:Sql Server分页分段查询百万级数据四种项目实例 - 浪礁 - 博客园
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY id ASC) AS rowid,* FROM [DBName].[dbo].[tabName]
) t
WHERE t.rowid > 100000 AND t.rowid <= 100050;