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
>