Delete duplicate record

If you need leave one record from few duplicates, you can use next SQL script

delete from table_1
 where rowid not in (select max_rowid
                       from (select field_1, field_2, max(rowid) as max_rowid
                               from table_1
                              group by field_1, field_2))

Script description: we grouping record and get unique identificator via pseudo column rowid, and after deleting all record from table except selecting unique records

Last comment

Name* E-mail

Code*