Equivalent of LIMIT and OFFSET for SQL Server?

Question

In PostgreSQL there is the `Limit` and `Offset` keywords which will allow very easy pagination of result sets. What is the equivalent syntax for Sql Server?

Answer 1

SELECT *

FROM

table

ORDER BY

column

OFFSET ? ROWS

FETCH NEXT ? ROWS ONLY;