Removing identical lines

-- Удаление одинаковых строк в таблице с двумя текстовыми столбцами Name и Surname
WITH cte AS (
    SELECT
        ROW_NUMBER() OVER (PARTITION BY Name, Surname ORDER BY Name) AS RN
    FROM
        dbo.Test
)
DELETE FROM cte WHERE RN > 1;