select * from tablename where id in (
select id from tablename 
group by id 
having count(id) > 1
)