/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

5 votes322 views1 answer
Find table from column name in sql
SQL
11 votes341 views1 answer
Oracle view source
SQL
8 votes336 views10 answers
Sql
SQL
10 votes311 views4 answers
Primary key sql
SQL
0 vote323 views1 answer
Mysql conf.d exampel
SQL
0 vote363 views1 answer
Having all mysql
SQL
8 votes283 views1 answer
Similarities between ddl and dml
SQL
0 vote314 views1 answer
Why mysql is used?
SQL
0 vote326 views1 answer
Make a socket server to detect changes in mysql
SQL
3 votes342 views2 answers
How to open postgresql in windows
SQL