如何在SQL Server中将分组扩展到row_number

I have the following:

我有以下内容：

DECLARE @TABLE1 TABLE
(
    VAL1 VARCHAR(2),
    VAL2 VARCHAR(2)
)

INSERT INTO @TABLE1 
VALUES ('A', 'X'), ('A', 'Y'), ('A', 'Z'),
       ('B', 'X'), ('B', 'Y'),
       ('C', 'X'), ('D', 'X')
DECLARE @TABL