MySQL find duplicate repords example

select address, count(address) as cnt
from mailing_list
group by address
having cnt > 1
order by cnt;

Thank you for reading this article MySQL find duplicate repords example With URL http://x-tutorials.blogspot.com/2005/04/mysql-find-duplicate-repords-example.html. Also a time to read the other articles.