Doing a group by query but need to sort on a different field

[Danny]

HI,

I am trying to do a group by such as this:
"select code, colors from productdb group by code, colors"

I need to sort on the key field, but cannot throw in the 'ordre by key',
because i will get that 'not part of an aggregate function error'

i could add it to the aggregate function, but it will return too many
records as I just want to return the unique code and color options.

what to do?

[John Winterbottom]

"Danny" <da********@hotmail.com> wrote in message
news:N9**********************@news4.srv.hcvlny.cv. net...

HI,

I am trying to do a group by such as this:
"select code, colors from productdb group by code, colors"

I need to sort on the key field, but cannot throw in the 'ordre by key',
because i will get that 'not part of an aggregate function error'

i could add it to the aggregate function, but it will return too many
records as I just want to return the unique code and color options.

what to do?

select code, colors from productdb
group by code, colors
order by min(id)

[Danny]

Hi John,

WOW, that did it!!
You saved me much pain.

Thanks again
Danny

"John Winterbottom" <as******@hotmail.com> wrote in message
news:2s*************@uni-berlin.de...

"Danny" <da********@hotmail.com> wrote in message
news:N9**********************@news4.srv.hcvlny.cv. net...

HI,

I am trying to do a group by such as this:
"select code, colors from productdb group by code, colors"

I need to sort on the key field, but cannot throw in the 'ordre by key',
because i will get that 'not part of an aggregate function error'

i could add it to the aggregate function, but it will return too many
records as I just want to return the unique code and color options.

what to do?

select code, colors from productdb
group by code, colors
order by min(id)