Cacher is the code snippet organizer for pro developers

WITH a as
(
SELECT [InsertAtributeHere], ROW_NUMBER() OVER(PARTITION by [InsertAtributeHere] ORDER BY [InsertAtributeHere]) 
AS duplicateRecCount
FROM dbo.table
)

Select * from a
WHERE a.duplicateRecCount > 1

--Delete Duplicate Records
--DELETE FROM a
--WHERE a.duplicateRecCount > 1