SQL Server Limit Offset

[hexus]

Implement this.

SELECT TOP {$limit} {$query_select} FROM (
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS row_number, {$query}...
) query_results WHERE row_number >= {$offset}

[hexus]

This is such a pain. Microsoft, why you gotta be such a pain?!

[hexus]

Wasn't particularly fun, but all done now. Laravel does it nicely too; row_num between offset and limit.