Country structure duplicates: Difference between revisions
Jump to navigation
Jump to search
Created page with "<pre>SELECT gazetteer.parentgazetteer_guid, gazetteer.gazetteername, Count(gazetteer.gazetteer_guid) FROM gazetteer GROUP BY gazetteer.parentgazetteer_guid, gazetteer.gazettee..." |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | <pre> | ||
SELECT | |||
gazetteer.parentgazetteer_guid, | gazetteer.parentgazetteer_guid, | ||
gazetteer.gazetteername, | gazetteer.gazetteername, | ||
| Line 10: | Line 11: | ||
HAVING | HAVING | ||
Count(gazetteer.gazetteer_guid) > '1' | Count(gazetteer.gazetteer_guid) > '1' | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 18:03, 12 February 2014
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'