Row Offset in SQL Server - Stack Overflow

I've been searching for this answer for a while now (for generic queries) and found out another way of doing it on SQL Server 2000+ using ROWCOUNT and cursors and without TOP or any temporary table. Using the SET ROWCOUNT [OFFSET+LIMIT] you can limit ...

stackoverflow.com