/*Demo Table*/
DROP TABLE T1

CREATE TABLE T1
  (
     C INT PRIMARY KEY
  );

   WITH
    E1(N) AS
    (
        SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
        SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
        SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1
    )                                       -- 1*10^1 or 10 rows
    , E2(N) AS (SELECT 1 FROM E1 a, E1 b)   -- 1*10^2 or 100 rows
    , E4(N) AS (SELECT 1 FROM E2 a, E2 b)   -- 1*10^4 or 10,000 rows
    , E8(N) AS (SELECT 1 FROM E4 a, E4 b)   -- 1*10^8 or 100,000,000 rows
    INSERT INTO T1
    SELECT TOP (10000000) ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS N
    FROM   E8

/*Queries*/
SELECT *
FROM   (SELECT ROW_NUMBER() OVER (ORDER BY C) AS ROW
        FROM   T1) A
WHERE  ROW BETWEEN 100 AND 120

SELECT *
FROM   (SELECT ROW_NUMBER() OVER (ORDER BY C) AS ROW
        FROM   T1) A
WHERE  ROW BETWEEN 9700000 AND 9700020