1SELECT username, email, COUNT(*)
2FROM users
3GROUP BY username, email
4HAVING COUNT(*) > 1
5
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 username, email, COUNT(*)
2FROM users
3GROUP BY username, email
4HAVING COUNT(*) > 1