Find duplicate rows and keep the latest one, delete the rest

Asked Jul 10 '14 at 05:55

Active Jul 10 '14 at 05:55

Viewed 55 times

For example, [row 1] and [row 3] have duplicate values on column A and column B, I need to delete [row 1], any one know how to do in PostgreSQL? (or other SQL server..)

           [column A]    [column B]
[row 1]    "/100/"       "0.gif"
[row 2]    "/101/"       "0.gif"
[row 3]    "/100/"       "0.gif"
[row 4]    "/100/"       "1.gif"

This question is similar to Delete duplicated old rows and keep only latest mysql but the code there is not working in Postgres(9.1.9)

edited May 23 '17 at 10:32

Community

asked Jul 10 '14 at 05:55

ahgood

1,847
20
19

2

How would you identify the "latest" row? Is there a datetime field to use? – Joachim Isaksson Jul 10 '14 at 05:59
More questions of this kind: https://stackoverflow.com/search?q=postgresql+delete+duplicate – Jul 10 '14 at 06:13
Thanks, there is no any datetime field, but a increasing id field, the greater number is the latest. – ahgood Jul 10 '14 at 06:16
Found this answer http://stackoverflow.com/a/23956441/641484 solved my question. – ahgood Jul 10 '14 at 07:09

Find duplicate rows and keep the latest one, delete the rest

0 Answers0

Linked