354 bytes added,
06:56, 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'''
<pre>
SELECT
accident.accident_localid,
Count(accident.accident_guid)
FROM
accident
GROUP BY
accident.accident_localid
HAVING
Count(accident.accident_guid) > '1'
<pre/>
[[Category:NoPublic]]
[[Category:SQL Queries]]