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