/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

1 vote138 views1 answer
Sql server if exists update else insert
SQL
2 votes123 views1 answer
Postgresql drop primary key constraint
SQL
0 vote115 views1 answer
Implicit inner join table alias with id values
SQL
0 vote108 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote121 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote108 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote121 views1 answer
C# execute transact sql
SQL
1 vote107 views1 answer
Mysql show data from table
SQL
1 vote121 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote119 views1 answer
Mysql match in serialized data
SQL