The Example
Solution
Solution1
DELETE p FROM Person p, Person q WHERE p.Id>q.Id AND q.Email=p.Email
Solution2
DELETE FROM Person WHERE Id NOT IN ( SELECT A.Id FROM (SELECT Min(Id) as Id FROM Person GROUP BY Email) A )
Another Clear Form:
DELETE FROM Person
WHERE Id NOT IN (
SELECT * FROM (
SELECT Min(Id)
FROM Person
GROUP BY Email
) Tmp
)