Re: duplicates
From: Beth J. Katcher <katcher_at_a1.tch.harvard.edu>
Date: 1995/08/01
Message-ID: <3vl7hi$mcl_at_netope.harvard.edu>#1/1
Date: 1995/08/01
Message-ID: <3vl7hi$mcl_at_netope.harvard.edu>#1/1
ucfaabe_at_ucl.ac.uk (Mr Angus Beare) wrote:
>
>I have a table that I want to create a unique index for
>but I can't because of duplicates. Oracle won't tell
>me where they are.
>
>Does anyone know a quick way to find duplicate records?
>
>thanks for any suggestions
>
>Gus
>
>--
>Angus Beare
Suppose you have a table called tab_w_dupes with 3 columns: f1, f2, and f3.
select f1, f2, f3, count(*)
from tab_w_dupes
group by f1, f2, f3
having count(*) > 1;
Beth Received on Tue Aug 01 1995 - 00:00:00 CEST