how to count non duplicate emails in mysql code example
Example: find duplicate keys in mysql
SELECT col, COUNT(col) FROM table_name GROUP BY col HAVING COUNT(col) > 1;
SELECT col, COUNT(col) FROM table_name GROUP BY col HAVING COUNT(col) > 1;