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_at_newsread2.nexgo.de>
Date: Tue, 24 Jul 2001 11:04:07 +0200
Message-ID: <9jjdjc$esa$1_at_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 - 11:04:07 CEST