Re: find duplicates

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