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/>
'''Accident ID'''
<pre>
ORDER BY
location.location_localid ASC
</pre>
'''Location name''' (not a Saved search)
<pre>
SELECT
trim(location.locationname),
Count(location.location_guid)
FROM
location
GROUP BY
trim(location.locationname)
HAVING
Count(location.location_guid) > '1'
ORDER BY
trim(location.locationname) ASC
</pre>
'''MRE ID'''
mre.mre_localid ASC
</pre>
'''QAID'''
<pre>
SELECT
ORDER BY
qa.qa_localid ASC
</pre>
'''Victim ID'''
<pre>
SELECT
victim.victim_localid,
Count(victim.victim_guid)
FROM
victim
GROUP BY
victim.victim_localid
HAVING
Count(victim.victim_guid) > '1'
ORDER BY
victim.victim_localid ASC
</pre>
'''Victim First name, Last name and Date of birth''' This query may need to be adopted if the country use CDFs or ''Age''
<pre>
SELECT
trim(victim.givenname),
trim(victim.familyname),
victim.dateofbirth,
Count(victim.victim_guid)
FROM
victim
GROUP BY
trim(victim.givenname),
trim(victim.familyname),
victim.dateofbirth
HAVING
Count(victim.victim_guid) > '1'
ORDER BY
trim(victim.givenname) ASC,
trim(victim.familyname) ASC,
victim.dateofbirth ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
