Support pagination (LIMIT and OFFSET) for Microsoft SQL Server

[lippserd]

Microsoft SQL Server supports pagination using OFFSET and FETCH.
This is an extension to the ORDER BY clause and supported since Microsoft SQL Server 2012.

[lippserd]

http://sqlfiddle.com/#!18/d01d3/1/0

[lippserd]

If the query does not specify an ORDER BY clause, we just add ORDER BY 1. Thanks @Thomas-Gelf for this hint.