NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
HAVING
Count(accident.accident_guid) > '1'
ORDER BY
accident.accident_localid ASC
</pre>
'''Hazard ID'''
HAVING
Count(hazard.hazard_guid) > '1'
ORDER BY
hazard.hazard_localid ASC
</pre>
'''HazRed ID'''
HAVING
Count(hazreduc.hazreduc_guid) > '1'
ORDER BY
hazreduc.hazreduc_localid ASC
</pre>
'''Location ID'''
HAVING
Count(location.location_guid) > '1'
ORDER BY
location.location_localid ASC
</pre>
'''MRE ID'''
<pre>
SELECTmre.mre_localid,Count(mre.mre_guid)FROMmreGROUP BYmre.mre_localidHAVINGCount(mre.mre_guid) > '1'ORDER BYmre.mre_localid ASC</pre>'''QA'''<pre>SELECTqa.qa_localid,Count(qa.qa_guid)FROMqaGROUP BYqa.qa_localidHAVINGCount(qa.qa_guid) > '1'ORDER BYqa.qa_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
