Answers for "mysql remove duplicate enctrys"

SQL
4

mysql delete duplicates

DELETE FROM CONTACTS
WHERE ID NOT IN
      (SELECT *
       FROM (SELECT max(ID)		
             FROM CONTACTS
             GROUP BY EMAIL) t);
 -- ⇓ Test it ⇓ (Fiddle source link)
Posted by: Guest on July-13-2021
0

mysql delete duplicate rows except one

DELETE FROM NAMES
 WHERE id NOT IN (SELECT * 
                    FROM (SELECT MIN(n.id)
                            FROM NAMES n
                        GROUP BY n.name) x)
Posted by: Guest on July-18-2020

Code answers related to "mysql remove duplicate enctrys"

Code answers related to "SQL"

Browse Popular Code Answers by Language