Re: How to find Duplicate records

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 27 Jul 2001 12:32:04 -0500
Message-ID: <u3d7it8qh.fsf_at_verizon.net>


On 23 Jul 2001, Shahid.Mahmood_at_team.telstra.com wrote:

> I am trying to find out the duplicate records in the table
> which contains over 10 million records. Could you please let me
> know the easiest and quickest way to get it done.

Okay, pointing to the Coop FAQ, (referenced later in the thread) http://www.jlcomp.demon.co.uk/faq/duplicates.html, you can find the answer, but it will also contain how to get rid of them.

Should the FAQ have two questions.

  1. Finding dups
  2. Getting rid of dups?
-- 
Galen Boyer
It seems to me, I remember every single thing I know.
Received on Fri Jul 27 2001 - 19:32:04 CEST

Original text of this message