Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: De-duplication of large table
Dave wrote in message >...
>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.
>
delete your_table
where rowid in (select min(rowid)
from your_table where any_condition group by (what columns determine 'duplicates') having count(rowid) > 1);
I did something similar earlier in the week and it seemed to run a lot quicker than the other methods I tried. Received on Sat Nov 20 1999 - 14:38:15 CST