Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> comp.databases.oracle -> SQL to retrieve min value of the combination

SQL to retrieve min value of the combination

From: Ravindra Harve <rharve_at_hotmail.com>
Date: 7 Jan 2004 09:30:57 -0800
Message-ID: <835dd0ad.0401070930.575a25ba@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 - 11:30:57 CST

This message: [ Message body ]
Next message: KENNY L. CHEN: ""Union all" and "UNION" ???? Return the same result or not ??"
Previous message: Ray: "query results slow from db"
Next in thread: Mark C. Stock: "Re: SQL to retrieve min value of the combination"
Reply: Mark C. Stock: "Re: SQL to retrieve min value of the combination"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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