Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> how to extract duplicates from a hugh database quickly
I am working with a table that contains 100,000,000 records. I want to
quickly filter out all of the duplicate records (w/o checking the date) and
then display the maximum date for the duplicates. Example
rec1 1/1/01 fieldValue1 fieldValue2 rec x 12/30/00 fieldValue1 fieldValue2
...
Create a recordset listing the latest (relative to the date) duplicate records quickly.
Any ideas Received on Tue Oct 23 2001 - 15:42:01 CDT