/SQL/Identify rows with 2 same column value and delete duplicate mysql

Identify rows with 2 same column value and delete duplicate mysql

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;

Source: mysqltutorial.org

Identify rows with 2 same column value and delete duplicate mysql

DELETE c1 FROM contacts c1
INNER JOIN contacts c2 
WHERE
    c1.id > c2.id AND 
    c1.email = c2.email;Code language: SQL (Structured Query Language) (sql)

Source: mysqltutorial.org

Similar codes

1 vote217 views2 answers
Extract weekday from date in sql
SQL
0 vote199 views1 answer
How to connect pgadmin with excel
SQL
1 vote211 views2 answers
How to search date in sql query
SQL
0 vote225 views1 answer
Call object contructor and call methods of object
SQL
0 vote200 views1 answer
Oracle create package specification
SQL
0 vote215 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote218 views1 answer
Mysql exception output
SQL
1 vote203 views1 answer
Does insert into overwrite sql
SQL
1 vote192 views1 answer
Substr sql last character
SQL
0 vote219 views1 answer
How to read the potentail error messages in ssis package
SQL