SELECT * FROM [dbo].[HttpRunLog_20240812] t1
JOIN (select id from [dbo].[HttpRunLog_20240812]
order by id
offset 120000 rows
fetch next 10 rows only ) t2
ON t1.id = t2.id
03-20
10-11
SELECT * FROM [dbo].[HttpRunLog_20240812] t1
JOIN (select id from [dbo].[HttpRunLog_20240812]
order by id
offset 120000 rows
fetch next 10 rows only ) t2
ON t1.id = t2.id