In TSQL, TOP cannot be mixed with OFFSET; use a FETCH clause instead!

Bad:

select top 10 Id, Name
from Users
order by Name
offset 0 rows

Good:

select Id, Name
from Users
order by Name
offset 0 rows
fetch next 10 rows only