duplicates.sql

select cdomain
    into temp duplicates_2
    from accounts
    group by cdomain
    having count(*) > 1;

select *
    from duplicates_2
    full join accounts
        on duplicates_2.cdomain = accounts.cdomain;