Postgres Pro
Downloads
Home   >   mailing lists

Select Question - Mailing list pgsql-general

From Alex
Subject Select Question
Date
Msg-id 401E6B35.6060109@meerkatsoft.com
Whole thread Raw
Responses Re: Select Question  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Hi,
I need to remove duplicate records from a table like

Code         Date
XS111111     2004-01-26
XS111111     2003-01-22
XS222222     2004-02-01
XS222222     2004-01-26
XS222222     2003-01-22

where only the newest record of Code XSxxxxxxx is kept in the table. Is
there an easy way to do that?

Thanks
Alex

pgsql-general by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Re: business references for postgresql
Next
From: Richard Huxton
Date:
Subject: Re: Return Value of a Function