delete p2 from Person as p1, Person as p2
where p2.Id > p1.Id and p2.Email = p1.Email;
delete p2 from Person as p1, Person as p2
where p2.Id > p1.Id and p2.Email = p1.Email;
delete p2 from Person as p1, Person as p2
where p2.Id > p1.Id and p2.Email = p1.Email;
delete p2 from Person as p1, Person as p2
where p2.Id > p1.Id and p2.Email = p1.Email;