/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 vote162 views1 answer
Less mysql display
SQL
0 vote155 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote138 views1 answer
Insert thai language sql server
SQL
0 vote191 views5 answers
How to make trigger in phpmyadmin
SQL
4 votes200 views1 answer
Mysql query first character
SQL
0 vote200 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
3 votes162 views1 answer
Oracle user privileges
SQL
0 vote237 views1 answer
Postgresql powershell query
SQL
0 vote151 views1 answer
Groupby error in mysql
SQL
0 vote150 views1 answer
Mysql create table columns with spaces
SQL