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.