select distinct fieldName,Count(fieldName) as c from people group by fieldName having Count(fieldName)>1