delete from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1)
也可以这样写
delete from people
where rowid in (select max(rowid) from people group by peopleid having count(peopleid) > 1);