/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

12 votes171 views1 answer
How to change the value of a table in sql
SQL
0 vote178 views2 answers
How to count codition
SQL
0 vote240 views1 answer
Liquibase update row
SQL
0 vote193 views1 answer
Stratified sampling sql
SQL
0 vote177 views1 answer
Setval in postgres
SQL
0 vote172 views1 answer
Find all tables where column name exists oracle
SQL
0 vote168 views1 answer
Create table if not exist with exceptions
SQL
0 vote172 views1 answer
Get duplicate entry sql
SQL
0 vote169 views1 answer
Mysql concat and use as where column
SQL
6 votes169 views4 answers
How to remove unique key in mysql
SQL