Get Duplicate Record from SQL Table

1) SELECT ContactEmailAddress, COUNT(ContactEmailAddress) AS NumOccurrences FROM CustomerMaster GROUP BY ContactEmailAddress HAVING ( COUNT(ContactEmailAddress) > 1 )


2) SELECT ContactEmailAddress FROM CustomerMaster GROUP BY ContactEmailAddress HAVING ( COUNT(ContactEmailAddress) = 1 )