Hi, I used the following SQL Query to determine Duplicate Records with same Name & Email in the row:
SELECT email, COUNT(email) AS NumOccur1, name, COUNT(name) AS NumOccur2 FROM mytbl GROUP BY name, email HAVING ( COUNT(email) > 1 ) AND ( COUNT(name) > 1 ) I want to delete all the records which are duplicate, leaving the original record as it is. How can I delete Only the Duplicate records? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
