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 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)