|
Posted by Kleist on 09/28/84 11:24
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
Navigation:
[Reply to this message]
|