select 字段名,count(id) as count from 数据库 group by 字段名 having count>1