Contact Duplicates

Last Modified on 18/07/2017 4:15 pm EDT

SELECT contactname,
       count(1) AS cnt
FROM tblcontact
GROUP BY Contactname
HAVING count(1) >1;