deletefrom people where peopleId in (select peopleId from people groupby peopleId havingcount(peopleId) > 1) and rowid notin (selectmin(rowid) from people groupby peopleId havingcount(peopleId )>1)
deletefrom vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae groupby peopleId,seq havingcount(*) > 1) and rowid notin (selectmin(rowid) from vitae groupby peopleId,seq havingcount(*)>1)
select * from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1) and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)