SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test (id int, age int, name varchar(20), surname varchar(20))
insert into test values (1, 20, 'test1', 'test_1')
1 rows affected

insert into test values (2, 30, 'test2', 'test_2')
1 rows affected

insert into test values (3, 40, 'test3', 'test_3')
1 rows affected

insert into test values (4, 50, 'test4', 'test_4')
1 rows affected

WITH cs AS 
( SELECT row_number() OVER( ORDER BY id ) AS rownum
         , id
         , age
         , name
         , surname
  FROM test
) select *
  from cs
  WHERE rownum >= 0 
       AND rownum < 3
  order by rownum;


rownum
id
age
name
surname


1
1
20
test1
test_1

2
2
30
test2
test_2