/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 vote284 views1 answer
Sqlite create index
SQL
0 vote288 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote270 views1 answer
How to check if there is no database schema
SQL
0 vote281 views1 answer
How to use lower case in mysql
SQL
0 vote270 views1 answer
Minecraft duping allowed servers
SQL
0 vote305 views1 answer
Faire une recherche par liste de mot clé sql
SQL
1 vote324 views1 answer
Postgresql if 0 then 1
SQL
0 vote322 views1 answer
Get total and distict row diff in sql
SQL
0 vote290 views1 answer
Oracle temporary table
SQL
1 vote316 views1 answer
Ora-01109 database not open in oracle 19c
SQL