SQL Saved search Duplicate ID: Difference between revisions
Jump to navigation
Jump to search
Created page with "These queries finds duplicates on ID. They are added to V6.0 as Saved searches with a syntax that works as Saved search '''Accident''' <pre> SELECT accident.accident_localid, ..." |
No edit summary |
||
| Line 11: | Line 11: | ||
HAVING | HAVING | ||
Count(accident.accident_guid) > '1' | Count(accident.accident_guid) > '1' | ||
<pre | </pre> | ||
'''Hazard''' | |||
<pre> | |||
SELECT | |||
hazard.hazard_localid, | |||
Count(hazard.hazard_guid) | |||
FROM | |||
hazard | |||
GROUP BY | |||
hazard.hazard_localid | |||
HAVING | |||
Count(hazard.hazard_guid) > '1' | |||
</pre> | |||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | [[Category:SQL Queries]] | ||
Revision as of 06:00, 13 February 2014
These queries finds duplicates on ID. They are added to V6.0 as Saved searches with a syntax that works as Saved search Accident
SELECT accident.accident_localid, Count(accident.accident_guid) FROM accident GROUP BY accident.accident_localid HAVING Count(accident.accident_guid) > '1'
Hazard
SELECT hazard.hazard_localid, Count(hazard.hazard_guid) FROM hazard GROUP BY hazard.hazard_localid HAVING Count(hazard.hazard_guid) > '1'