mysql查询重复

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