/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

2 votes181 views1 answer
Tcl in sql
SQL
0 vote137 views1 answer
Execute sql stored procedure in powershell
SQL
2 votes163 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote201 views1 answer
Mysql get nested records
SQL
3 votes140 views1 answer
Sql case update
SQL
0 vote138 views1 answer
Pl sql join 3 tables
SQL
0 vote147 views1 answer
Value of sold product using having and group by in sql
SQL
57 votes329 views6 answers
Sql alter table
SQL
36 votes156 views3 answers
Add column in mysq
SQL
-1 vote143 views2 answers
Postgresql get last 10 records
SQL