Generates table of rows with duplicate values based on column

get_dupes.sql

select t.*
from table t
join
    (
        select column_with_dupes
        from table
        group by column_with_dupes
        having count(column_with_dupes) > 1
    ) using (column_with_dupes)