Delete duplicate records keeping one record

CREATE TABLE #SampleTable
(
	ID INT,
	[Name] VARCHAR(100)
)

INSERT INTO #SampleTable	
SELECT 1, 'Yahoo' UNION ALL
SELECT 1, 'Yahoo' UNION ALL
SELECT 2, 'Google' UNION ALL
SELECT 2, 'Google' UNION ALL
SELECT 2, 'Google'

--Before Deleting the duplicate rows
SELECT * FROM #SampleTable;

WITH CTE AS
(
	SELECT ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [Name]) AS Row, * FROM #SampleTable
)


DELETE FROM CTE
WHERE ROW <> 1

--After Deleting the duplicate rows
SELECT * FROM #SampleTable

DROP TABLE #SampleTable