simple (not for me) question

From: Kleist <kleist_at_tlen.pl>
Date: Thu, 18 Aug 2005 12:45:58 +0300
Message-ID: <de1lcu$3l2$1@news.uar.net>

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 Received on Thu Aug 18 2005 - 04:45:58 CDT