Finds duplicate records in a table

dupe-find.sql

;WITH [CTE] AS (
    SELECT 
        [Field],
        COUNT(1) AS [Count]
    FROM [dbo].[Table]
    GROUP BY [Field]
)
SELECT [T].[Field]
FROM [Table] [T]
INNER JOIN [CTE] ON [T].[Field] = [CTE].[Field]
WHERE [CTE].[Count] > 1