Re: Duplicate records

Sushama Belkhode wrote:
>
> Can anyone tell me how to weed out duplicate records from a large(> 1
> million records) table quickly and efficiently?
>
> Thanks in advance
>
> Sushama

If you know what field is duplicated, then:

select duplicate_field
from table
group by duplicated_field
having count(*) > 1;

This should work for you. Received on Fri Aug 15 1997 - 00:00:00 CDT