sql Find Duplicates

SELECT
	Column1, 
	COUNT(Column1) AS NumberOfOccurrences
FROM TableName
GROUP BY Column1
HAVING ( COUNT(Column1) > 1 )
Finds duplicate records within a database.

Updated: Saturday 9th October 2010, 09:47pm

Share Snippet

There are 0 comments

Leave a comment of your own

Comments are currently closed.