180608_find_duplicate

Write a SQL query to find all duplicate emails in a table named Person.

For example, your query should return the following for the above table:

SELECT DISTINCT p1.Email
FROM Person p1, Person p2
WHERE p1.Email = p2.Email 
    AND p1.Id > p2.Id