NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
These queries finds duplicates on ID. They are added to V6.0 as Saved searches with a syntax that works as Saved search</br>'''AccidentID'''
<pre>
SELECT
Count(accident.accident_guid) > '1'
</pre>
'''HazardID'''
<pre>
SELECT
Count(hazard.hazard_guid) > '1'
</pre>
'''HazRed ID'''
<pre>
SELECT
hazreduc.hazreduc_localid,
Count(hazreduc.hazreduc_guid)
FROM
hazreduc
GROUP BY
hazreduc.hazreduc_localid
HAVING
Count(hazreduc.hazreduc_guid) > '1'
</pre>
'''Location ID'''
<pre>
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]