select id, count(*) from 
    sequence 
    group by id having count(*) > 1;