1SELECT name, COUNT(email)
2FROM users
3GROUP BY email
4HAVING COUNT(email) > 1
1SELECT [CaseNumber], COUNT(*) AS Occurrences
2FROM [CaseCountry]
3GROUP BY [CaseNumber]
4HAVING (COUNT(*) > 1)
1SELECT
2 col,
3 COUNT(col)
4FROM
5 table_name
6GROUP BY col
7HAVING COUNT(col) > 1;