+38 098 888 58 89 Alexander
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.
|powered by Steel Programming|