SQL: distinct on single field

[Heinrich Ruoff]

On 3/23/06, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
>
> On 3/22/06 1:43 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:
>
> > Thanks Igor this seems to be working!
>
> Actually Ivan



I'm sooo sorry Ivan!!! Hope you still answer my questions in future.

> Is it normal that in the result cursor the fields formerly named id now
> are
> > "No Name2" and Color now is "No Name 3"?
>
> You can self assign names if you want
>
> SELECT ProductCode, Min(Color) as 'min_color', Min(id) as 'min_id'
> FROM Products
> Group By ProductCode



Thanks Ruslan thats great!


Heinrich