SQL: distinct on single field

[Ruslan Zasukhin]

On 3/22/06 1:43 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:

> Thanks Igor this seems to be working!

Actually Ivan
 
> 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


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]