In my previous article SQL SERVER – Delete Duplicate Records – Rows, we have seen how we can delete all the duplicate records in one simple query. In this article we will see how to find count of all the duplicate records in the table. Following query demonstrates usage of GROUP BY, HAVING, ORDER BY in one query and returns the results with duplicate column and its count in descending order. This is how I count duplicate records in any table.
SELECT YourColumn, COUNT(*) AS TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESCWatch the video to see the above concept in action:
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
187 Comments. Leave new
Iam doing a e-commerce project , in that i need to get the count of all duplicate values of different products, can any one help me.
Thanks in advance.
You should post it in forums for quick help.