Re: A select DISTINCT query? - Mailing list pgsql-general

Hello

try

SELECT DISTINCT col FROM table

Pavel

On 27/01/2008, Phil Rhoades <phil@pricom.com.au> wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>