Skip to content

mysql tip: finding duplicated records

Found here: http://mysql-tips.blogspot.com/2005/04/mysql-find-duplicate-repords-example.html
select address, count(address) as cnt
from mailing_list
group by address
having cnt > 1
order by cnt;

Share This

Posted 24 September 2008 § postgresql § misc ‡ Comments (0)
Close
E-mail It