Changes

Jump to: navigation, search

Country structure duplicates

256 bytes added, 18:03, 10 February 2014
Created page with "<pre>SELECT gazetteer.parentgazetteer_guid, gazetteer.gazetteername, Count(gazetteer.gazetteer_guid) FROM gazetteer GROUP BY gazetteer.parentgazetteer_guid, gazetteer.gazettee..."
<pre>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'

</pre>
[[Category:NoPublic]]
6,632
edits

Navigation menu