/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

0 vote235 views1 answer
Modificar tipo de dato sql server
SQL
3 votes234 views1 answer
Oracle user quota on tablespace
SQL
-1 vote245 views1 answer
Mysql case when multiple conditions
SQL
0 vote228 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote290 views1 answer
How to rename a database in tsql
SQL
1 vote223 views2 answers
Postgresql list columns
SQL
2 votes232 views2 answers
Get all columns from table sql
SQL
0 vote243 views1 answer
Sql delete row from table where id
SQL
0 vote234 views1 answer
Sql contains numeric characters
SQL
0 vote264 views1 answer
Add week ending date sql server
SQL