Pagination, Filtering, Sorting with Total Row Count // SQL Server

gistfile1.sql

DECLARE @PageNumber AS INT, @RowsPerPage AS INT
SET @PageNumber = 1
SET @RowsPerPage = 20
SELECT * FROM (
             SELECT ROW_NUMBER() OVER(ORDER BY Id /* Sort example*/) AS [Meta.Index], COUNT(Id) OVER() [Meta.Total],
             i.* FROM Items i 
             WHERE Id > 5 AND Id < 20 -- Filter example
               ) AS result 
WHERE [Meta.Index] BETWEEN ((@PageNumber - 1) * @RowsPerPage + 1) AND (@PageNumber * @RowsPerPage) -- Pagination
ORDER BY [Meta.Index]