SQL SERVER -- Duplicate Records in DB

This query will get the duplicate records from the database table


SELECT YourColumn, COUNT(YourColumn) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(YourColumn) > 1