A select DISTINCT query?

From: Phil Rhoades <phil(at)pricom(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: A select DISTINCT query?
Date: 2008-01-27 14:05:39
Message-ID: 1201442739.28880.74.camel@prix.pricom.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

People,

I want to select from a table ONLY unique records ie if a column has
values:

1
2
3
3
4
5

I want ONLY these records returned:

1
2
4
5

Thanks,

Phil.
--
Philip Rhoades

Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Fax: +61:(0)2-8221-9599
E-mail: phil(at)pricom(dot)com(dot)au

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-01-27 14:10:17 Re: A select DISTINCT query?
Previous Message Lawrence Oluyede 2008-01-27 13:38:18 Re: Possible bug in PostgreSQL 8.3beta4 (postgres process segfaults)