Web Global Net Web Application & Web Development Project Center

Technical Issues => MySQL => Topic started by: admin on August 31, 2022, 03:49: PM



Title: Finding Duplicate Records and the total in a Mysql Database
Post by: admin on August 31, 2022, 03:49: PM
SELECT marketing_email, COUNT(marketing_email) 
FROM Email_Marketing 
GROUP BY marketing_email 
HAVING COUNT(marketing_email) > 1;

This will count and display duplicate records and the individual totals for each duplicate