Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wgn/public_html/support/Sources/Load.php(225) : runtime-created function on line 3

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wgn/public_html/support/Sources/Load.php(225) : runtime-created function on line 3
Finding Duplicate Records and the total in a Mysql Database
Web Global Net Web Application & Web Development Project Center
March 21, 2025, 08:47: AM *

:
 
      
Web Global Net Web Application & Web Development Project Center > Technical Issues > MySQL > : Finding Duplicate Records and the total in a Mysql Database
: [1]   
   |   
: Finding Duplicate Records and the total in a Mysql Database  ( 3434 )
0 1
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
 
:  

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.