CODE EXAMPLE FOR SQL

select rows with same value in a column

SELECT email,
       count(*) AS c
FROM TABLE
GROUP BY email
HAVING c > 1
ORDER BY c DESC