Mysql delete duplicate rows

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)

Source: grepper.com

Mysql delete duplicate rows but keep one

DELETE c1 FROM contacts c1
INNER JOIN contacts c2 
WHERE
    c1.id > c2.id AND 
    c1.email = c2.email;

Source: mysqltutorial.org

Delete all duplicate rows keep the latest except for one in mysql

DELETE 
FROM
  `tbl_job_title` 
WHERE id NOT IN 
  (SELECT 
    * 
  FROM
    (SELECT 
      MAX(id) 
    FROM
      `tbl_job_title` 
    GROUP BY NAME) tbl)

Source: stackoverflow.com

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

Source: grepper.com

Similar codes

0 vote123 views1 answer
Oracle list user locked
SQL
0 vote112 views1 answer
How to convert external table to managed table in hive
SQL
1 vote128 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote105 views1 answer
Not between mysql
SQL
7 votes105 views1 answer
Sql server convert string to date
SQL
51 votes214 views6 answers
Opera gx
SQL
11 votes116 views2 answers
Safe mode off mysql
SQL
15 votes133 views4 answers
Mysql export database command line
SQL
0 vote115 views1 answer
Where name ends in SQL
SQL
2 votes116 views1 answer
Guid to string sql
SQL