NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "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, ..."
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]]
'''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]]
