/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

13 votes315 views6 answers
Mysql update from select
SQL
6 votes330 views2 answers
Insert into select mysql
SQL
0 vote309 views1 answer
Run postgresql dump to csv
SQL
0 vote314 views1 answer
Mysql select all table that have field names
SQL
-2 votes326 views2 answers
Union vs union all in sql
SQL
50 votes379 views4 answers
Sql alter type of column
SQL
6 votes300 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote293 views1 answer
How to get inserted id in sql server
SQL
7 votes323 views2 answers
Oracle foreign key reference table
SQL
0 vote320 views1 answer
Replace content value from old to new sql
SQL