delete from t where name in (select name from t group by name having count(name)>1) and rowid not in (select min(rowid) from t group by name having count(name)>1)