/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 vote183 views1 answer
How to install mysql without admin rights
SQL
1 vote184 views2 answers
Begin transaction in sql
SQL
0 vote215 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
1 vote303 views1 answer
How to select department from table
SQL
0 vote204 views1 answer
Ubuntu connect to mssql database
SQL
0 vote166 views1 answer
Postrgres trunc
SQL
0 vote211 views1 answer
Mysql add text to existing field
SQL
1 vote169 views1 answer
Data type and their numeric form
SQL
0 vote191 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote261 views1 answer
<sql:datasource var="Snapsho"
SQL