Posted By

wirenaught on 04/23/11


Tagged


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

meetzah
vitor_np
jeremydouglass


find duplicate records


 / Published in: MySQL
 

  1. SELECT address, count(address) as cnt
  2. FROM mailing_list
  3. GROUP BY address
  4. HAVING cnt > 1
  5. ORDER BY cnt;

Report this snippet  

You need to login to post a comment.