/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 vote255 views1 answer
Which lock mode is not available in sql
SQL
1 vote203 views1 answer
Mysql average of multiple columns
SQL
1 vote207 views1 answer
Postgresql contains
SQL
0 vote204 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote209 views1 answer
How to to get time in sql
SQL
0 vote189 views1 answer
Postgres read table structure
SQL
0 vote175 views2 answers
Delete query sql server
SQL
0 vote184 views1 answer
Django how to get query result count
SQL
1 vote230 views1 answer
Difference between where and having clause
SQL
0 vote241 views1 answer
Sql set data from a select query to a temp table and insert
SQL