MySQL find duplicates

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.