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.