--怎么算重复，name相同就算吗？
delete from t where rowid not in(
    select rowid from t where rowid in(
        select max(rowid) from t group by name)
);

--还是name,age都相同才算？
delete from t where rowid not in(
    select rowid from t where rowid in(
        select max(rowid) from t group by name, age)
);