SteelProgramming | +38 098 888 58 89 Alexanders.berezovich Skypesteelprogram@gmail.com E-mail |
Delete duplicate recordIf 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 | |
powered by Steel Programming |