Nurhak Kaya's Software Development Blog

SELECT select *   from     (       select d.*       , count(*) over       (partition by adi) cnt       from ort_ilce_kodlari d     ) where cnt > 1; DELETE delete from ort_ilce_kodlari a        where rowid >         (           select min(rowid)           from ort_ilce_kodlari b           where a.adi = b.adi         );