SQL Saved search Duplicate ID

From IMSMA Wiki
Revision as of 05:56, 13 February 2014 by Alnaucler (talk | contribs) (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, ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 

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









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