Country structure duplicates

From IMSMA Wiki
Revision as of 17:03, 10 February 2014 by Alnaucler (talk | contribs) (Created page with "<pre>SELECT gazetteer.parentgazetteer_guid, gazetteer.gazetteername, Count(gazetteer.gazetteer_guid) FROM gazetteer GROUP BY gazetteer.parentgazetteer_guid, gazetteer.gazettee...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search 
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'
Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Country_structure_duplicates&oldid=13518"