Tag: Find duplicate record

Find duplicate repords in Table

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;

Permanent link to this article: https://blog.openshell.in/2010/12/find-duplicate-repords-in-table/