/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

5 votes126 views2 answers
Sql number columns
SQL
8 votes91 views2 answers
Alter column name in mssql
SQL
1 vote141 views1 answer
Change table to innodb mysql
SQL
0 vote139 views1 answer
Mysql reset wp_options
SQL
1 vote122 views1 answer
Set id count mysql
SQL
4 votes113 views1 answer
Sql list users and roles
SQL
0 vote95 views1 answer
Get last run query sql server
SQL
1 vote125 views1 answer
Oracle sql create view
SQL
0 vote135 views1 answer
Left join in codeigniter query builder
SQL
0 vote197 views1 answer
Placements hackerrank solution
SQL