/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 vote200 views1 answer
Mysql group by derived column
SQL
11 votes249 views2 answers
You are using safe update mode
SQL
0 vote260 views1 answer
Postgresql cast as year and month from timestamp
SQL
2 votes179 views2 answers
How to get capital letter first in sql
SQL
7 votes198 views1 answer
Oracle pagination query offset
SQL
7 votes196 views1 answer
Postgres base size
SQL
0 vote195 views1 answer
Group by two columns postgres
SQL
0 vote229 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote190 views1 answer
Output table plsql
SQL
3 votes196 views2 answers
Plsql print
SQL