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