Posted By

Neven on 11/14/11


Tagged

sql


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

vtoman
johnw


Find duplicate entries


 / Published in: SQL
 

Searches for duplicate entries in the DataBase table

  1. SELECT column1, COUNT(*) AS Expr1
  2. FROM table1
  3. GROUP BY column1
  4. HAVING (COUNT(*) > 1)

Report this snippet  

You need to login to post a comment.