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;
Query to find duplicate records with count in a specific column of a table Query to find duplicate records with count in a specific column of a table Reviewed by Ishan Dev Shukl on March 29, 2016 Rating: 5
Powered by Blogger.