if OBJECT_ID('tempdb..#t') is not null 
	drop table #t

Create table #t (Id int, [Name] int)

insert into #t (Id, [Name])
Values
(1,	1)
,(2,	2)
,(3,	1)
,(4,	1)
,(5,	2)
,(6,	3)
,(7,	4)
,(8,	5)
,(9,	6)
,(10,	7)

-- Поиск
Select a.Id [Parent_Id], a.[Name] [Parent_Name], b.Id [Double_Id], b.[Name] [Doudle_Name]
	from #t a inner join #t b on a.Name = b.Name and a.Id > b.Id
Order by a.Name, a.Id

-- Удаление
;With tt as
(Select *, ROW_NUMBER() over (partition by [Name] order by Id DESC, 1/0 ) N from #t)
Delete from tt Where N>1

Select * from #t