find duplicate records - MySQL Snipplr Social Repository

Revision: 45057

at April 23, 2011 00:33 by wirenaught

Initial Code

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

Initial URL

Initial Description

Initial Title

find duplicate records

Initial Tags

Initial Language

MySQL