From: Jules Alberts <jules.alberts@arbodienst-limburg.nl>
To: pgsql-sql@postgresql.org
Subject: filtering out doubles
Date: Wed, 12 Mar 2003 11:03:35 +0100
Message-ID: <20030312100410.BBFD01CB1A5@koshin.dsl.systemec.nl> (raw)
Hello everyone,
I was wondering how to filter out double values (where "value" spans
two columns COL1 and COL2) with a SELECT statement. If I have this
table:
COL1 |COL2 |COL3
-----------------------------
a |b |some value
a |b |another value
a |c |yet another value
what would be the select statement to get this result:
COL1 |COL2 |COL3
-----------------------------
a |b |some value
a |c |yet another value
I was thinking that DISTINCT would do this, but I don't want to loose
COL3. TIA for any tips!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jules.alberts@arbodienst-limburg.nl
Subject: Re: filtering out doubles
In-Reply-To: <20030312100410.BBFD01CB1A5@koshin.dsl.systemec.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox