/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 vote356 views1 answer
How to find total working hour in sql
SQL
0 vote351 views1 answer
How to install postgresql on wsl
SQL
0 vote331 views1 answer
Empty table sqlite
SQL
0 vote559 views1 answer
The differnece between to values in sql
SQL
0 vote394 views1 answer
Site:av.ru "files"
SQL
7 votes320 views1 answer
Mysql unsafe update
SQL
0 vote318 views1 answer
How to connect to mysql in ef 6
SQL
14 votes343 views6 answers
Auto_increment mysql
SQL
0 vote339 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote326 views1 answer
2020 new year
SQL