Posted By

Neven on 11/14/11

Tagged

Viewed 633 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)

Comment:

You need to login to post a comment.