Country structure duplicates

SELECT
gazetteer.parentgazetteer_guid,
gazetteer.gazetteername,
Count(gazetteer.gazetteer_guid)
FROM
gazetteer
GROUP BY
gazetteer.parentgazetteer_guid,
gazetteer.gazetteername
HAVING
Count(gazetteer.gazetteer_guid) >  '1'