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))
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