/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 vote215 views1 answer
How to rename a database in tsql
SQL
0 vote163 views1 answer
Tsql pad left
SQL
-1 vote190 views1 answer
Search all sql tables for a value
SQL
4 votes235 views2 answers
Sql select except null
SQL
0 vote136 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote148 views1 answer
Copy Table from SQL to CSV
SQL
1 vote150 views1 answer
Too many connections mysql
SQL
0 vote144 views1 answer
Lost connection to mysql
SQL
-1 vote155 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote150 views4 answers
Creating a comment and reply system PHP and MySQL
SQL