Posted by Kleist on 10/09/50 11:24

Hilarion wrote:

>
> Try this:
>
> SELECT MIN( id ) AS res_id
> FROM some_table
> GROUP BY prod_nr
> ORDER BY 1
>


Thank you very much! Without the ordering works great.

• Next in forum: Re: slightly OT, sql question
• Prev in forum: Re: slightly OT, sql question
• Thread view: Re: slightly OT, sql question

[Reply to this message]