how to find the total duplicate records in our table

Saratvaddilli
Posted by Saratvaddilli under Sql Server category on | Points: 40 | Views : 967
SELECT ColumnName, COUNT(*) TotalCount

FROM OurTable

GROUP BY ColumnName

HAVING COUNT(*) > 1

Comments or Responses

Login to post response