/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 vote155 views1 answer
Add new column in sql with foreign key
SQL
0 vote138 views1 answer
How to check which table has data in mysql
SQL
3 votes117 views1 answer
Oracle list user grants
SQL
11 votes135 views2 answers
Safe mode off mysql
SQL
1 vote528 views1 answer
How to lock table in mysql
SQL
0 vote127 views3 answers
Create and attach user to a postgresql database
SQL
2 votes196 views1 answer
Mysql create user with remote access
SQL
13 votes168 views6 answers
Mysql remove duplicates
SQL
1 vote102 views1 answer
Mysql get last insert id
SQL
1 vote200 views1 answer
Oracle create program if not exists
SQL