重复数据

select 字段,count(*) as count from 数据表 group by 字段 having count>1;