思路1 使用GROUP BY

SELECT email
FROM Person
GROUP BY email
HAVING COUNT(*)>1;