/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 vote239 views1 answer
How to compile a function in oracle
SQL
0 vote211 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote187 views1 answer
Sql change default collation to utf8
SQL
0 vote194 views1 answer
SQL add a totals of differemt rows of the same id
SQL
4 votes185 views1 answer
Oracle delete last row
SQL
0 vote180 views1 answer
Oracle right characters
SQL
0 vote176 views1 answer
Mysql isshow
SQL
3 votes186 views1 answer
Sql is not like
SQL
2 votes184 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote178 views2 answers
Sqlalchemy core in clause
SQL