CODE EXAMPLE FOR SQL

select rows with same value in a column

select * from table where email in (
    select email from table
    group by email having count(*) > 1
)