Finding Duplicates in a table

To find duplicate records in your table, run the following query:


SELECT
   name,email, COUNT(*)
FROM
    reports
GROUP BY
    name,email
HAVING 
    COUNT(*) > 1

Author: Dev

Full Stack Developer at one of the largest Banks in Canada.