How do I extract duplicates out of a HUGE table

From: DCCoolBreeze <DelawareKD_at_starpower.net>
Date: Tue, 23 Oct 2001 17:09:44 -0400
Message-ID: <9r4m2l$ns9$1_at_bob.news.rcn.net>


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 - 23:09:44 CEST

Original text of this message