/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

3 votes184 views1 answer
Unsigned int in mysql
SQL
0 vote207 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote193 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote193 views1 answer
Tsql find procedure with name
SQL
-1 vote174 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
92 votes312 views6 answers
Substring
SQL
1 vote181 views1 answer
Moodle query item quiz
SQL
-1 vote219 views1 answer
Ms sql select datetime as date
SQL
11 votes188 views2 answers
Having in sql
SQL
3 votes164 views1 answer
Mysql UPDate with enner join
SQL