WITH cte AS (
    SELECT *,
        ROW_NUMBER() OVER (PARTITION BY Customer_ID ORDER BY Rank1 DESC) rn
    FROM @RankTable
)

DELETE
FROM cte
WHERE rn = 1;