Re: How to find Duplicate records

From: Falko Rotter <fantomas99_at_gmx.de>
Date: Tue, 24 Jul 2001 11:04:07 +0200
Message-ID: <9jjdjc$esa$1@newsread2.nexgo.de>

> Hi
>
> 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.
>

the easiest way is (but not the quickest !)

select duplicate_field, count(duplicate_field) from 10_Million_Table
group by duplicate_field
having count(duplicate_field)>1

Regards,
Falko Rotter

Software Developer -

Rotter & Kalweit Softwaredesign GbR
Friemarer Straße 38

99867 Gotha
GERMANY mail: news_at_falko-rotter.de Received on Tue Jul 24 2001 - 04:04:07 CDT