CODE EXAMPLE FOR SQL

sql query to find duplicate email address

select Id, email, From Person Group BY Id, email  Having Count(*) > 1