Changes

SQL Saved search Duplicate ID

183 bytes added, 07:08, 13 February 2014

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/br>

'''Accident ID'''

<pre>

</pre>

'''Location ID'''

<pre>

SELECT

location.location_localid,

Count(location.location_guid)

FROM

location

GROUP BY

location.location_localid

HAVING

Count(location.location_guid) > '1'

</pre>

'''MRE ID'''

<pre>

6,632

edits