Posted By

Neven on 11/14/11

Tagged

Viewed 1527 times

Favorited by 1 user(s)

/ 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)

You need to login to view comments.