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 -> Urgent Help With A SELECT

Urgent Help With A SELECT

From: HornDog <brianbom_at_mail.pacifier.com>
Date: 1997/07/23
Message-ID: <5r46lt$9ko$2@news.pacifier.com>#1/1

Given the following table

table_a

route available capacity

11           1200            3000
11           1400            2000
11            900            5000

I need a query that will return a single row that has the minimum "available"
value of the three rows and the corresponding "capacity".

I wrote the following query that returns '900', but how can I get the '5000'
that goes along with it?

SELECT route, MIN(available)
FROM table_a
WHERE route=11
GROUP BY route;

Any help would be appreciated ASAP!

Brian

PS.
What I need to see back from the query is:

Available Capacity

900 5000 Received on Wed Jul 23 1997 - 00:00:00 CDT

Original text of this message

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