Registration Forgot password?
Login
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

Name*E-mail
Code*