Sql Server Paging

We can return only a page from a large query's resultset with the following construct :

SELECT * FROM
(
SELECT Client.*, ROW_NUMBER() OVER (ORDER BY ClientID) AS RowNumber
FROM Client
) AS NumberedRows
WHERE RowNumber BETWEEN @StartRowIndex AND (@StartRowIndex + @MaximumRows - 1);