SQL Server - Select a subset of data in SELECT query

Select a subset of data in SELECT query

DECLARE @times int
SET @times = 2

SELECT field1, field2
   FROM (SELECT field1, field2, row_number() OVER(PARTITION BY field1 ORDER BY field1 DESC) AS rowNumber FROM Table) AS t
WHERE t.rowNumber <= @times;