/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 vote263 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote253 views1 answer
Nth max in my sql
SQL
0 vote263 views1 answer
Sql DATE = GETDATE()
SQL
17 votes261 views6 answers
Get last record in sql
SQL
1 vote248 views1 answer
User privileges postgresql information_schema
SQL
0 vote285 views1 answer
Select distinct after join
SQL
2 votes237 views1 answer
Sql find missing values between two tables
SQL
0 vote253 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote247 views1 answer
Mysql drop multiple tables at once
SQL
1 vote263 views1 answer
Top 10 rows in mysql
SQL