/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 vote321 views1 answer
Php mysqli install
SQL
1 vote315 views1 answer
Sql server epoch to datetime
SQL
0 vote288 views1 answer
Get duplicate entry sql
SQL
0 vote317 views1 answer
Create table database in psql
SQL
1 vote293 views4 answers
Between vs in sql
SQL
2 votes349 views3 answers
Xampp mysql database not starting
SQL
16 votes314 views4 answers
Ascending order mysql
SQL
7 votes315 views3 answers
Add primary key to database sql
SQL
10 votes339 views5 answers
Create table mysql query
SQL
0 vote309 views1 answer
Case insensitive sql
SQL