Re: Removing duplicate records - OT

[Ronald J Kimball]

On Tue, Aug 14, 2001 at 11:12:23AM +1000, Neil Lunn wrote:

> Use something like this as the record source for items with duplicate email
> addresses:
> 
> select *
> from table
> where email in (
>   select email
>   from table
>   group by email
>   having count(*) > 1)
> 
> and delete every second record.

This approach would end up deleting the wrong records if the records aren't
returned in the expected order (you could add an order by to fix that), or
if any email appears more than twice.

Ronald