Re: select unique items in db - Mailing list pgsql-general

From Stijn Vanroye
Subject Re: select unique items in db
Date
Msg-id ee8bc4$11em$1@news.hub.org
Whole thread Raw
Responses Re: select unique items in db  ("a" <a@tempinbox.com>)
List pgsql-general
a schreef:
>  "select unique id" - i found this line in google search
> but i want to make
> select * as unique
>
> select unique * is
> or select distinct
>
> pls point out how to select unique items from a list of million items
>
Maybe
select distinct <fieldlist> from ...
or
select distinct on (field1,field2) <fieldlist> from ... ?

Regards,

Stijn.

pgsql-general by date:

Previous
From: "J S B"
Date:
Subject: Re: berkley sockets
Next
From: Alban Hertroys
Date:
Subject: Template1 oops