/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

1 vote109 views1 answer
How to get the date diff on once field in sql server
SQL
1 vote110 views1 answer
Oracle drop temporary table
SQL
0 vote121 views1 answer
Shows all databases created by user in ms sql
SQL
10 votes112 views4 answers
SELECT FROM WHERE
SQL
0 vote121 views1 answer
Sql query for login with email or username
SQL
5 votes129 views4 answers
Start postgres server
SQL
0 vote114 views1 answer
Oracle table privileges
SQL
15 votes112 views4 answers
Mysql where value is null
SQL
1 vote112 views1 answer
Sql find column name like
SQL
-1 vote103 views3 answers
Check table exist postgresql
SQL