/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 vote264 views1 answer
Sqlserver now
SQL
0 vote271 views1 answer
How to order result of subquery in select
SQL
0 vote276 views1 answer
Postgresql find missing id
SQL
4 votes299 views2 answers
Oracle unlock account
SQL
14 votes312 views4 answers
Sql compiler
SQL
2 votes284 views1 answer
Update with join sql server
SQL
0 vote267 views1 answer
Char varchar nvarchar sql
SQL
0 vote290 views1 answer
Adding generated time in row mysql workbench
SQL
1 vote286 views3 answers
Connect to mysql c# connection string C#
SQL
2 votes279 views1 answer
Sql server check for value in multiple columns
SQL