delete from tableName where rowname in (select rowname from tableName group by rowname having count(rowname) > 1) and rowid not in (select min(rowid) from tableName group by rowname having count(rowname)>1);