Find duplicates values and count in a column – SQL Server 2012

Following query will help you to find out the duplicate values and their count in a column.

SELECT column_name, COUNT(*) Duplicates_Count
FROM [dbo].[table_name]
GROUP BY column_name