/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 vote404 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote370 views1 answer
Max length found in mysql
SQL
1 vote387 views1 answer
How to use db.execute
SQL
1 vote344 views1 answer
Sql delete all values in a column
SQL
0 vote354 views2 answers
Sqlite unique
SQL
0 vote360 views1 answer
How to select even id in sql
SQL
2 votes367 views2 answers
How to rename column name in sql server using query
SQL
2 votes330 views2 answers
Insert all in sql
SQL
14 votes427 views4 answers
Sql compiler
SQL
0 vote391 views3 answers
Select top 10 rows in sql
SQL