/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 vote263 views1 answer
Full sql mode
SQL
0 vote263 views1 answer
Psql list view rules
SQL
0 vote280 views1 answer
Express api ith mysql data
SQL
3 votes269 views1 answer
Fk in insert mysql
SQL
12 votes242 views4 answers
SQL Where
SQL
0 vote230 views1 answer
Create duplicate table in postgresql
SQL
0 vote244 views1 answer
Install mysql 8 linux
SQL
0 vote261 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
4 votes284 views2 answers
Float postgres
SQL
0 vote264 views1 answer
How to get data between a last week in mysql
SQL