/SQL/How to delete all duplicate items in mysql

How to delete all duplicate items in mysql

DELETE FROM FriendsData WHERE fID 
       NOT IN ( SELECT fID FROM FriendsData 
                   GROUP BY UserID, FriendsUserID, IsSpecial, CreatedBy)

Similar codes

0 vote247 views1 answer
Copy row from db to db mysql
SQL
0 vote203 views1 answer
How to locate pg_hba.conf file
SQL
0 vote180 views1 answer
Java spring boot connect to sql server
SQL
7 votes185 views3 answers
Postgresql dump and restore db
SQL
11 votes200 views6 answers
Mysql else if
SQL
0 vote196 views3 answers
Group_concat sql server
SQL
0 vote214 views2 answers
Plpgsql
SQL
0 vote181 views1 answer
How to get data between a last week in mysql
SQL
0 vote193 views1 answer
Watch mysql command line
SQL
0 vote199 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL