Posted By

Neven on 11/14/11

Tagged

1 person have marked this snippet as a favorite

/ Published in: SQL

Searches for duplicate entries in the DataBase table

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

Comment:

You need to login to post a comment.