Hi,
Try

DELETE FROM YourTable ;
WHERE YourKey NOT IN (SELECT MIN(YourKey) ;
FROM YourTable ;
GROUP BY YourKey, TestField1, TestField2, etc)

Not Tested

>Hi All:
>
>What's the easiest and most elegant way to remove the SECOND duplicate. IOW, when there is a dupe, get rid of the second record.
>
>Thanks,
>
>Yossi