Re: Removing duplicate records - OT

[Bart Lateur]

On Tue, 14 Aug 2001 11:12:23 +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.

Next question: how do you delete every second record? Quickly?

-- 
        Bart.