/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

1 vote163 views1 answer
Postgres check blocking
SQL
6 votes237 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
8 votes170 views3 answers
Connect python to mysql
SQL
1 vote171 views1 answer
OstgreSQL version
SQL
0 vote167 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote164 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote170 views3 answers
How to increase size of column in sql
SQL
9 votes183 views5 answers
Laravel to sql
SQL
2 votes167 views1 answer
Check isolation level in mysql
SQL
9 votes201 views3 answers
Sequence postgresql
SQL