/ Published in: SQL
Searches for duplicate entries in the DataBase table
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT column1, COUNT(*) AS Expr1 FROM table1 GROUP BY column1 HAVING (COUNT(*) > 1)