Home > mailing lists

How to remove duplicate lines but save one of the lines? - Mailing list pgsql-general

From	A B
Subject	How to remove duplicate lines but save one of the lines?
Date	July 21, 2008 15:34:08
Msg-id	dbbf25900807210833y649b5d0as21d18282dd28aa13@mail.gmail.com Whole thread Raw
Responses	Re: How to remove duplicate lines but save one of the lines? Re: How to remove duplicate lines but save one of the lines? Re: How to remove duplicate lines but save one of the lines? Re: How to remove duplicate lines but save one of the lines? Re: How to remove duplicate lines but save one of the lines?
List	pgsql-general

Tree view

I have a table with rows like this
A 1
A 1
B 3
B 3
C 44
C 44
and so on.

and I want it to be
A 1
B 3
C 44

so how can I remove the all the duplicate lines but one?

pgsql-general by date:

From: Richard Huxton
Date: 21 July 2008, 14:18:45
Subject: Re: Problems using Grails with Postgresql

From: Raymond O'Donnell
Date: 21 July 2008, 15:42:01
Subject: Re: How to remove duplicate lines but save one of the lines?

How to remove duplicate lines but save one of the lines? - Mailing list pgsql-general

Previous

Next