/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 vote183 views1 answer
Create a view in sqlite
SQL
3 votes212 views5 answers
No module named 'MySQLdb'
SQL
1 vote180 views1 answer
Sql bitwise operators
SQL
1 vote190 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote198 views1 answer
Sql cmd no truncate
SQL
0 vote209 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote174 views1 answer
Sql remove last x char
SQL
0 vote251 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote198 views1 answer
Postgresql isnull with max
SQL
1 vote196 views1 answer
Best sql course
SQL