Re: select distinct

Never mind.  I figure out that what
I am asking is not possible

Sorry for the noise

On Sun, Aug 12, 2001 at 08:39:35PM -0400, news wrote:
> It seems that I cannot get other columns
> with distinct in the select statement.
>
> I want to do like
>     select distinct i,a from a where c=2;
>
> Right now I have to do
>     select distinct i from a where c=2
> and then iterate over each i to get a
>
> I have also tried
>     select a,distinct i from a where c=2
>
> I would appreciate any suggestion
>
> Thanks
>