SQL Saved search Duplicate ID

From IMSMA Wiki
Revision as of 06:08, 13 February 2014 by Alnaucler (talk | contribs)
Jump to navigation Jump to search

These queries finds duplicates on ID. They are added to V6.0 as Saved searches with a syntax that works as Saved search
Accident ID 

SELECT
accident.accident_localid,
Count(accident.accident_guid)
FROM
accident
GROUP BY
accident.accident_localid
HAVING
Count(accident.accident_guid) >  '1'

Hazard ID 

SELECT
hazard.hazard_localid,
Count(hazard.hazard_guid)
FROM
hazard
GROUP BY
hazard.hazard_localid
HAVING
Count(hazard.hazard_guid) >  '1'

HazRed ID 

SELECT
hazreduc.hazreduc_localid,
Count(hazreduc.hazreduc_guid)
FROM
hazreduc
GROUP BY
hazreduc.hazreduc_localid
HAVING
Count(hazreduc.hazreduc_guid) >  '1'

Location ID 

SELECT
location.location_localid,
Count(location.location_guid)
FROM
location
GROUP BY
location.location_localid
HAVING
Count(location.location_guid) >  '1'

MRE ID
Retrieved from "http://mwiki.gichd.org/IM/index.php?title=SQL_Saved_search_Duplicate_ID&oldid=13718"