/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 vote346 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote375 views1 answer
Dropping a constraint in ms sql
SQL
0 vote339 views2 answers
Mysql select date from datetime
SQL
1 vote381 views1 answer
Sqlalchemy on delete set null
SQL
0 vote378 views4 answers
Convert databse to achieve log mode oracle
SQL
4 votes387 views1 answer
Rename stored procedure in sql server
SQL
-1 vote350 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
1 vote330 views1 answer
Mysql server does not start mac
SQL
1 vote342 views3 answers
Sql select only time from datetime
SQL
0 vote362 views1 answer
How to login to mysql in homestead
SQL