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