/ Published in: MySQL
Expand |
Embed | Plain Text
SELECT address, count(address) as cnt FROM mailing_list GROUP BY address HAVING cnt > 1 ORDER BY cnt;
You need to login to post a comment.
wirenaught on 04/23/11
3 people have marked this snippet as a favorite
SELECT address, count(address) as cnt FROM mailing_list GROUP BY address HAVING cnt > 1 ORDER BY cnt;
You need to login to post a comment.