ORDER BY (columnsName) OFFSET( @Limit * (@Offset -1) ) ROWS FETCH NEXT @Limit ROWS ONLY SELECT col1, col2, ... FROM ... WHERE ... ORDER BY -- this is a MUST there must be ORDER BY statement -- the paging comes here OFFSET 10 ROWS -- skip 10 rows FETCH NEXT 10 ROWS ONLY; -- take 10 rows