/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

2 votes322 views1 answer
Foreign key example in dbms
SQL
0 vote369 views1 answer
Sql contains numeric characters
SQL
0 vote357 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote363 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote373 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
5 votes354 views1 answer
Postgresql functions
SQL
15 votes416 views3 answers
Mysql update add to existing value
SQL
0 vote359 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote360 views2 answers
Advantages of stored procedures sql
SQL
0 vote429 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL