/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

4 votes121 views3 answers
Oracle sql first day of quarter
SQL
0 vote159 views1 answer
Get first monday of month sql
SQL
3 votes129 views1 answer
How to check schema privileges in oracle
SQL
5 votes150 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
2 votes92 views4 answers
Mysql change database character set to utf8mb4
SQL
2 votes133 views1 answer
Mysql create user with mysql_native_password
SQL
6 votes142 views4 answers
Mysql get random row
SQL
60 votes302 views6 answers
Add column in sql
SQL
0 vote136 views1 answer
Soql user profile
SQL
0 vote127 views1 answer
Add column in sql server ubuntu
SQL