Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> simple (not for me) question

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US