Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

fwd


Find Duplicate Rows


 / Published in: SQL
 

  1. -- Select Duplicates
  2. SELECT [COLUMN], COUNT([COLUMN]) AS NumOccurrences
  3. FROM [TABLENAME]
  4. GROUP BY [COLUMN]
  5. HAVING ( COUNT([COLUMN]) > 1 )

Report this snippet  

You need to login to post a comment.