select EMAIL, count(EMAIL) as cnt
from TABLE
group by EMAIL
having cnt > 1 ORDER BY `cnt` DESC
The above MySQL query will find and list the number of multiple duplicate emails in a table.
Toronto based web development
select EMAIL, count(EMAIL) as cnt
from TABLE
group by EMAIL
having cnt > 1 ORDER BY `cnt` DESC
The above MySQL query will find and list the number of multiple duplicate emails in a table.