Postgres Pro
Downloads
Home   >   mailing lists

A select DISTINCT query? - Mailing list pgsql-general

From Phil Rhoades
Subject A select DISTINCT query?
Date
Msg-id 1201442739.28880.74.camel@prix.pricom.com.au
Whole thread Raw
Responses Re: A select DISTINCT query?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: A select DISTINCT query?  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
Tree view 
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@pricom.com.au

pgsql-general by date:

Previous
From: "Lawrence Oluyede"
Date:
Subject: Re: Possible bug in PostgreSQL 8.3beta4 (postgres process segfaults)
Next
From: "Pavel Stehule"
Date:
Subject: Re: A select DISTINCT query?