Try this....
delete from table where rowid=(select max(rowid) from table group by dup_field_name having count(*) > 2)



Thanks...