/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

18 votes126 views2 answers
Sql inner join
SQL
0 vote127 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
1 vote130 views2 answers
Mysql join two tables
SQL
21 votes127 views1 answer
SQL cheat sheet pdf
SQL
0 vote144 views1 answer
Sql log file inof
SQL
1 vote134 views1 answer
Postgres convert exisiting column to text
SQL
0 vote127 views1 answer
Data structures in sql
SQL
0 vote90 views1 answer
Update set with join pl sql
SQL
23 votes137 views3 answers
Sql where contains part of string
SQL
4 votes137 views3 answers
Count with where
SQL