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;