/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 vote228 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
4 votes198 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote204 views1 answer
Mysql where in keep order
SQL
2 votes215 views1 answer
Where clause for child record apex
SQL
2 votes183 views1 answer
Ifnull postgres
SQL
0 vote222 views2 answers
Mysql calcular idade
SQL
-1 vote205 views1 answer
How to create foreign key in sql server management studio
SQL
-1 vote194 views2 answers
Postgresql user permissions to database
SQL
0 vote216 views1 answer
Timestamp(0) postgresql
SQL
8 votes184 views3 answers
Duplicate entry
SQL