|
Posted by Kleist on 09/28/93 11:24
Kleist wrote:
> Hello,
>
> I have a table like this:
>
> ID | prod_nr | rate
> ----|----------|------------
> 1 | 23 | 8
> 2 | 29 | 11.3
> 3 | 230 | 3
> 4 | 23 | 16.2
> 5 | 23 | 4
>
> I am new in sql, and don`t know how to get list of
> ID's for distinct list of prod_nr. I need to have the result like this.
>
> res_id
> -------
> 1
> 2
> 3
>
> Thanks in advance for any clue in this question
Never mind, solved already
Navigation:
[Reply to this message]
|