Re: duplicates

In article <1995Aug1.115212.57550_at_ucl.ac.uk>, ucfaabe_at_ucl.ac.uk (Mr Angus Beare) says:
>
>
>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

You could do it in SQL*Plus like this:

Select your_field, count(*)
from your_table
group by your_field
having count(*) > 1;

Mats Larsson. Received on Thu Aug 03 1995 - 00:00:00 CEST