Skip navigation

How to find duplicates in an MSSQL database

  • July 15, 2014 – 11:04 am
  • Posted in MSSQL

Here’s a quick way to find the duplicates in an MSSQL database:

SELECT item,
COUNT(item) AS numoccurrences
FROM sbDatabaseTable
GROUP BY item
HAVING(COUNT(item)>1)

Enjoy