select 字段名,count(*) from table group by 字段名 having count(*) > 1 select name1,name2,count(*) from table group by name1,name2 having count(*) > 1