Project / Support Center
Welcome, %1$s. Please login or register. February 28, 2024, 09:42: AM
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  : Finding Duplicate Records and the total in a Mysql Database 0 and 1 Guest are viewing this topic. « previous next »
: [1]
: Finding Duplicate Records and the total in a Mysql Database  ( 2773 )
admin
Administrator
******


: 239


« : 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
 

The Unknown Webmaster
: [1]  
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  : Finding Duplicate Records and the total in a Mysql Database « previous next »
:  


Powered by MySQL Powered by PHP Valid XHTML 1.0! Valid CSS!
Sorry, the copyright must be in the template.
Please notify this forum's administrator that this site is missing the copyright message for SMF so they can rectify the situation. Display of copyright is a legal requirement. For more information on this please visit the Simple Machines website.