SQL Server 2019

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))
create table test2 (id int, workplace int)
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

insert into test2 values (1, 2)
1 rows affected

insert into test2 values (2, 3)
1 rows affected

WITH cs AS 
( SELECT row_number() OVER( ORDER BY t.id ) AS rownum
         , t.id
         , t.age
         , t.name
         , t.surname
         , t2.workplace
  FROM test t
  left join test2 t2 on t.id = t2.id
) select *
  from cs
  WHERE rownum >= 0 
       AND rownum < 4
  order by rownum;


rownum
id
age
name
surname
workplace


1
1
20
test1
test_1
2

2
2
30
test2
test_2
3

3
3
40
test3
test_3
null


SELECT  top 3 t.id
         , t.age
         , t.name
         , t.surname
         , t2.workplace
FROM test t
left join test2 t2 on t.id = t2.id


id
age
name
surname
workplace


1
20
test1
test_1
2

2
30
test2
test_2
3

3
40
test3
test_3
null


SELECT   t.id
         , t.age
         , t.name
         , t.surname
         , t2.workplace
FROM test t
left join test2 t2 on t.id = t2.id
ORDER BY t.id
OFFSET 1 ROWS
FETCH NEXT 1 ROWS ONLY;


id
age
name
surname
workplace


2
30
test2
test_2
3