Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: find duplicates

Re: find duplicates

From: Guido Konsolke <Konsolke_at_triaton.com>
Date: Tue, 14 Jan 2003 13:40:35 +0100
Message-ID: <1042548038.367175@news.thyssen.com>


What about:
select data, count(*)
from ...
group by data
having count(*) > 1;

hth,
Guido

"s Lehaire" <s.lehaire_at_meilleuregestion.com> schrieb im Newsbeitrag news:b00t5c$mvq$1_at_reader1.imaginet.fr...
> Hi I have to create a primary key on a table but I've got a duplicate data
> in this table
> so i try to find a sql request to find the duplicat rows
> can you help me ?
>
>
Received on Tue Jan 14 2003 - 06:40:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US