/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 vote248 views1 answer
Set column width in sqlplus
SQL
0 vote252 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote291 views1 answer
For select oracle
SQL
0 vote260 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
9 votes266 views4 answers
Oracle get table column names
SQL
6 votes247 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote269 views3 answers
How to assign custom id in mysql
SQL
4 votes260 views2 answers
Convert utc to est sql
SQL
9 votes243 views6 answers
Sql insert into
SQL
0 vote266 views1 answer
Selecting all columns from table sql database
SQL