Here is an example to find duplicate records from the table.
select address, count(address) as cnt from mailing_list group by address having cnt > 1 order by cnt;
Dec 10
Find duplicate repords in Table
Permanent link to this article: https://blog.openshell.in/2010/12/find-duplicate-repords-in-table/