Re: Deleting duplicates

Another method you may consider is:

  This will identify the duplicates,

   select column
     from table alias
    where rowid > (select min (rowid)

                     from table
                    where column = alias.column);

    This will delete the duplicates,

   delete from table alias

      where rowid > (select min (rowid)
                     from table
                     where column = alias.column);

Avoid future duplicate row insertion by placing a primary key constraint on the table. Received on Thu Jun 20 1996 - 00:00:00 CEST