Steel
Programming
+38 098 888 58 89 Alexander
s.berezovich Skype
steelprogram@gmail.com E-mail
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.