Re: De-duplication of large table

There are many ways, depending on other factors, but the easiest way is to

CREATE TABLE newtable AS SELECT DISTINCT * FROM oldtable;

then drop the oldtable and rename the newtable to the oldtable's name.

There are some disadvantages to doing it this way, but, as I said, it depends on what you ultimately need to do.

Dave <none_at_nowhere.nothere.oops> wrote in message news:811m34$na5$1_at_lure.pipex.net...
> I have a 43,000,000 row table with about 225,000
> duplicate records.
> What is the easiest way to remove the duplicates.
> I want to remove one of every duplicate record
> from the table.
>
> Dave
>
>
>
Received on Thu Nov 18 1999 - 14:23:26 CST