/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

9 votes356 views3 answers
Pyodbc connect to sql server
SQL
7 votes368 views1 answer
Show line number in sql server
SQL
1 vote324 views1 answer
Sql server get users
SQL
3 votes324 views1 answer
Sql server check version
SQL
0 vote321 views3 answers
Find below average salary in sql
SQL
1 vote329 views1 answer
Moodle query first user access
SQL
3 votes332 views1 answer
Force using index oracle
SQL
1 vote326 views2 answers
Mysql join two tables
SQL
0 vote332 views1 answer
How many rows affected in sqllite
SQL
0 vote349 views1 answer
Check the size of the tables here ordered from the biggest size
SQL