/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

12 votes224 views1 answer
How to change the value of a table in sql
SQL
0 vote236 views1 answer
Postgresql not in alternative
SQL
0 vote237 views1 answer
Oracle shrink table
SQL
3 votes223 views2 answers
Mysql add 2 hours
SQL
0 vote271 views1 answer
Python mysql check if database exists
SQL
0 vote257 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote256 views1 answer
Primary key multiple
SQL
0 vote227 views1 answer
Postgres where
SQL
0 vote227 views1 answer
Mariadb mysql root access denied
SQL
0 vote227 views1 answer
Grant access on table in oracle
SQL