/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

24 votes236 views5 answers
Import dump mysql
SQL
0 vote233 views1 answer
SQL Server Enterprise
SQL
5 votes222 views1 answer
How to check nls format in oracle
SQL
0 vote242 views1 answer
Migration graphql
SQL
0 vote230 views1 answer
Test the postgresql db connection
SQL
3 votes239 views1 answer
Postgresql if null then 0
SQL
0 vote224 views1 answer
Mysql command line ubuntu
SQL
6 votes221 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote225 views2 answers
Sql server set default value equal to auto increment
SQL
16 votes245 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL