Find duplicate entries


/ Published in: SQL
Save to your folder(s)

Searches for duplicate entries in the DataBase table


Copy this code and paste it in your HTML
  1. SELECT column1, COUNT(*) AS Expr1
  2. FROM table1
  3. GROUP BY column1
  4. HAVING (COUNT(*) > 1)

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.