mysql查询重复

select * from tablename where id in (   
select id from tablename   

group by id   
having count(id) > 1   
)