delete from TableName where exists (select * from TableName a where a.field1=TableName.field1 and 
a.field2=TableName.field2 group by field1,field2 having count(*) > 1)
and TableName.rowid not in (select min(rowid) from TableName group by field1,field2 having count(*)>1)