MySQL bietet die LIMIT und OFFSET Klausel.
Um eine derartige Funktionalität im Microsoft SQL DBMS zu erhalten, muss man über die Zielen-Nummern gehen.
;WITH Results_SOME_QUERY AS (SELECT *, ROW_NUMBER() OVER (ORDER BY SOME_FIELD) AS RowNum FROM MY_TABLE WHERE SOME_FIELD = SOME_VALUE ) SELECT * FROM Results_SOME_QUERY WHERE RowNum >= @OFFSET AND RowNum < @OFFSET + @LIMIT
Ressourcen
https://msdn.microsoft.com/de-de/library/ms186734.aspx
https://dev.mysql.com/doc/refman/5.7/en/select.html
http://stackoverflow.com/questions/2135418/equivalent-of-limit-and-offset-for-sql-server