Thursday, December 17, 2015

Example in sql of how to list out duplicates.

SELECT        Institution_Name, Institution_City, Institution_State, Institution_Country, COUNT(*) AS TotalCount
FROM            Institution_Lookup
GROUP BY Institution_Name, Institution_City, Institution_State, Institution_Country
HAVING        (COUNT(*) > 1)
ORDER BY Institution_Name

No comments:

Post a Comment