/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

6 votes208 views1 answer
Oracle pl sql source
SQL
1 vote200 views1 answer
Get parameter value in mysql trigger
SQL
0 vote179 views1 answer
Joins vs includes
SQL
0 vote190 views1 answer
Oracle create job if not exists
SQL
1 vote191 views1 answer
Get rows affected mysql python
SQL
0 vote243 views1 answer
Generate a random otp in sql server
SQL
5 votes205 views2 answers
Create function postgresql
SQL
1 vote201 views1 answer
Get count by weekly pivot table sql server
SQL
7 votes196 views4 answers
What is my mysql version
SQL
2 votes193 views1 answer
Oracle apex list connected users
SQL