Registration Forgot password?
Remember me
Login through VKontakte
General > Articles > Delete duplicate record

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

You can add comment on current page, or on forum page there.

Last comment