/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 vote170 views1 answer
Mysql limit order by
SQL
0 vote180 views1 answer
Mysql error codeigniter
SQL
1 vote171 views1 answer
Sql and
SQL
3 votes144 views2 answers
Sql server current date without time
SQL
0 vote296 views1 answer
Why do we need data structure in sql
SQL
2 votes137 views2 answers
Compare date mysql
SQL
0 vote151 views1 answer
Psql get table data types
SQL
1 vote162 views1 answer
Mysql workbench in ubuntu 14.04
SQL
1 vote151 views3 answers
Epoch to datetime
SQL
0 vote149 views1 answer
Sql where part of string match
SQL