How do I get count of distinct rows with duplicate email IDs in SQL?
ID NAME EMAIL
1 John [email protected]
2 Sam [email protected]
4 Bob [email protected]
5 Tom [email protected]
6 Rob [email protected]
7 Tic [email protected]
8 Dad [email protected]
The query should return 2. as [email protected] and [email protected] are duplicates
SELECT
COUNT(*)
FROM Users
GROUP BY EMail
HAVING ( COUNT(EMAIL) > 1 )
This query is returning some wierd results. Thanks