Testing beyond limits!

Search This Blog

Tuesday, March 29, 2016

Query to find duplicate records with count in a specific column of a table

Query to find duplicate records with the count of their occurrence in a specific column of a table:

SELECT column_name,COUNT(*) AS count
FROM  table_name
GROUP BY  column_name
HAVING count>1;