/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

0 vote103 views1 answer
Nueva tabla mysql
SQL
0 vote171 views1 answer
Drop check command
SQL
0 vote114 views1 answer
Fetching data from mysqldb
SQL
0 vote112 views1 answer
Select year from dual oracle
SQL
0 vote94 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote103 views2 answers
Tsql row number
SQL
0 vote187 views1 answer
Oracle sql alter view add column
SQL
1 vote105 views10 answers
Stack overflow
SQL
0 vote62 views2 answers
Avg() sql
SQL
0 vote108 views2 answers
How to take recent row without limit in mysql
SQL