/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

3 votes479 views6 answers
Sql unique select
SQL
0 vote279 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote290 views1 answer
Increase speed of like queries postgres
SQL
1 vote280 views1 answer
Add time to date sql
SQL
0 vote1.1K views1 answer
Mysql custom sort order
SQL
1 vote382 views1 answer
Difference between where and having clause
SQL
0 vote285 views1 answer
Sql remove last x char
SQL
4 votes303 views1 answer
Datepart postgres
SQL
0 vote303 views4 answers
Stored procedure sql
SQL
0 vote326 views1 answer
Use mysql in java program
SQL