/SQL/Mysql delete duplicate rows except one

Mysql delete duplicate rows except one

DELETE FROM NAMES
 WHERE id NOT IN (SELECT * 
                    FROM (SELECT MIN(n.id)
                            FROM NAMES n
                        GROUP BY n.name) x)

-1

Similar codes

-1 vote120 views1 answer
Auto increment psql not primary key
SQL
0 vote128 views1 answer
Sql remove first character from string
SQL
7 votes124 views3 answers
Foreign key oracle
SQL
0 vote121 views1 answer
St_buffer mysql
SQL
0 vote123 views1 answer
MySQL - Enabling the Event Scheduler
SQL
1 vote123 views1 answer
Set statiscis on in sql server
SQL
-1 vote126 views1 answer
How to change the auto increment in existing table mysql
SQL
3 votes121 views3 answers
Stop mysql service ubuntu
SQL
0 vote138 views1 answer
Postgres change the name of schema
SQL
10 votes84 views2 answers
Sql where clause multiple values
SQL