If the columns are defined as not null, just add a unique index on all
alter table ignore add unique(col1.col2.col#);
>Does anyone know a good way find and remove duplicate records from a table?
>I can create an identical table structure and use a script to pull records
>from the existing table and insert them into the new table if they are not
>duplicates, but I'd rather not do it that way. Here is an example of an sql
>script I use for Oracle databases
>delete from employee a
>where rowid < (
>from employee b
>where b.COL1 = a.COL1
>and b.COL2 = a.COL2
>and b.COL# = a.COL#);
>Thanks in advance!