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