This article describes how to delete a single row, when it is found that row is duplicated

Set Rowcount 1
Delete From
Table
Where
ID = 999 (Or any field name/value combination that identifies the duplicate row)
Set Rowcount 0