/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

6 votes209 views1 answer
Update left join mysql
SQL
0 vote208 views1 answer
Join in update query in mysql
SQL
0 vote220 views1 answer
Mysql conf.d exampel
SQL
0 vote210 views1 answer
Oracle synonym procedure
SQL
-1 vote228 views4 answers
Restart mysql server ubuntu
SQL
0 vote208 views1 answer
Get server date mysql
SQL
1 vote218 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote212 views1 answer
Postgres drop type
SQL
0 vote208 views1 answer
Sql roll up rows into columns
SQL
2 votes211 views1 answer
Mariadb select multiple rows into one column
SQL