As suggested above, there might be different versions of SQL on your server and your local.
In SQL Server 2012, there are two new arguments in the SELECT statement's ORDER BY clause that let you retrieve a fixed number of rows:
OFFSET <EXPR1> ROWS, which you use to specify the line number from which to start retrieving results
FETCH NEXT <EXPR2> ROWS ONLY, which you use to specify how many lines to
You can also go through this FETCH NEXT
Hope this will help you.