Breaking News: Grepper is joining You.com. Read the official announcement!

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

Add Answer

Hurt Hamster answered on April 17, 2020 Popularity 9/10 Helpfulness 3/10

answer delete all duplicate rows keep the latest except for one in mysql

related mysql delete duplicate rows but keep one

related mysql delete older duplicates

related how to delete all duplicate items in mysql

related mysql delete older duplicates

related identify rows with 2 same column value and delete duplicate mysql

related Remove duplicate old value in mysql

related mysql delete duplicate rows except one

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

Comment

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

Popularity 9/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: except mysql rows sql

Link to this answer
Share Copy Link

Contributed on Apr 26 2021

Hurt Hamster

0 Answers Avg Quality 2/10

Closely Related Answers

mysql delete duplicate rows but keep one

Comment

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

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.mysqltutorial.org

Tags: rows

Link to this answer
Share Copy Link

Contributed on Feb 04 2021

Stefan Schnabeltier

0 Answers Avg Quality 2/10

mysql delete older duplicates

Comment

DELETE FROM CONTACTS
WHERE ID NOT IN
      (SELECT *
       FROM (SELECT max(ID)		
             FROM CONTACTS
             GROUP BY EMAIL) t);
 -- ⇓ Test it ⇓ (Fiddle source link)

Popularity 10/10 Helpfulness 4/10 Language sql

Source: sqlfiddle.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jul 13 2021

VasteMonde

0 Answers Avg Quality 2/10

how to delete all duplicate items in mysql

Comment

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

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: items item

Link to this answer
Share Copy Link

Contributed on Apr 17 2020

Mobile Star

0 Answers Avg Quality 2/10

mysql delete older duplicates

Comment

 delete test
   from test
  inner join (
     select max(id) as lastId, email
       from test
      group by email
     having count(*) > 1) duplic on duplic.email = test.email
  where test.id < duplic.lastId;

Popularity 8/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Aug 17 2020

Powerful Penguin

0 Answers Avg Quality 2/10

identify rows with 2 same column value and delete duplicate mysql

Comment

DELETE c1 FROM contacts c1
INNER JOIN contacts c2 
WHERE
    c1.id > c2.id AND 
    c1.email = c2.email;
Code language: SQL (Structured Query Language) (sql)

Popularity 9/10 Helpfulness 3/10 Language sql

Source: www.mysqltutorial.org

Tags: identify identif

Link to this answer
Share Copy Link

Contributed on Dec 27 2021

Troubled Toad

0 Answers Avg Quality 2/10

Remove duplicate old value in mysql

Comment

DELETE `yellow_page_content`
   from `yellow_page_content`
  inner join (
     select max(`id`) as lastId, `code`
       from `yellow_page_content`
      group by `code`
     having count(*) > 1) duplic on duplic.code = yellow_page_content.code
  where yellow_page_content.id < duplic.lastId;

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Feb 01 2022

Blue-eyed Bison

0 Answers Avg Quality 2/10

mysql delete duplicate rows except one

Comment

-1

DELETE FROM NAMES
 WHERE id NOT IN (SELECT * 
                    FROM (SELECT MIN(n.id)
                            FROM NAMES n
                        GROUP BY n.name) x)

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: except ex

Link to this answer
Share Copy Link

Contributed on Jul 18 2020

masterDev

0 Answers Avg Quality 2/10

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

Contents

More Related Answers

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

Closely Related Answers

mysql delete duplicate rows but keep one

mysql delete older duplicates

how to delete all duplicate items in mysql

mysql delete older duplicates

identify rows with 2 same column value and delete duplicate mysql

Remove duplicate old value in mysql

mysql delete duplicate rows except one

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.