how to find the total duplicate records in our table

Posted by Saratvaddilli under Sql Server category on 1/2/2013 | Points: 40 | Views : 2358

SELECT ColumnName, COUNT(*) TotalCount

FROM OurTable

GROUP BY ColumnName

HAVING COUNT(*) > 1

Bookmark It

Latest Code Snipptes