mysql remove duplicates from query results code example
Example 1: mysql delete duplicate rows but keep one
DELETE c1 FROM contacts c1
INNER JOIN contacts c2
WHERE
c1.id > c2.id AND
c1.email = c2.email;
Example 2: mysql remove duplicates
DELETE t1 FROM contacts t1
INNER JOIN contacts t2
WHERE
t1.id < t2.id AND
t1.email = t2.email;Code language: SQL (Structured Query Language) (sql)