Here is a sample approach
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'
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
SELECT * FROM #SampleTable
DROP TABLE #SampleTable