Deleting a duplicate row without primary key.

ID	FirstName	LastName
1	Bob	Smith
2	Dave	Jones
3	Karen	White
1	Bob	Smith
1	Bob	Smith

2005:

DELETE TOP (SELECT COUNT(*) -1 FROM dbo.Emptest WHERE ID = '1') 
FROM dbo.customer2 
WHERE ID = '1'