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 -> SQL to retrieve min value of the combination

SQL to retrieve min value of the combination

From: HRR <harve_projects_at_yahoo.com>
Date: 7 Jan 2004 10:21:24 -0800
Message-ID: <53b2dd24.0401071021.4a9d3594@posting.google.com>


Hi,

I have the following table

1001 2 3
1001 3 5
1001 5 7
1002 5 4
1002 6 2

I need to get a result

1001 2 3
1002 6 2

How is it possible ? Received on Wed Jan 07 2004 - 12:21:24 CST

Original text of this message

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