Posted By

fugue on 05/05/10


Tagged

mysql deduplication


Versions (?)

Who likes this?

6 people have marked this snippet as a favorite

BrianCoyDesign
dantreacy
jearley
prevuk
mikael12
jeremydouglass


Find duplicate records


 / Published in: MySQL
 

  1. SELECT id, COUNT(*) as n
  2. FROM my_table
  3. GROUP BY id
  4. HAVING n >1;

Report this snippet  

You need to login to post a comment.