Delete from Tablo_Adi where ID in (

Select MAX(ID) as ID
From Tablo_Adi
Group By Kolon_Adi
Having Count (Kolon_Adi) > 1

)

Select Kolon_Adi as KLN, Count(Kolon_Adi) as ADET , MAX(ID) as ID
From Tablo_Adi
Group By Kolon_Adi
Having Count (Kolon_Adi) > 1