Re: Urgent Help With A SELECT

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/07/23
Message-ID: <33d60c1d.2147487@newshost>#1/1

On 23 Jul 1997 06:00:29 GMT, brianbom_at_mail.pacifier.com (HornDog) wrote:

>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 * from table_a
where ( route, available ) = (
>SELECT route, MIN(available)
>FROM table_a
>WHERE route=11
>GROUP BY route

);

will do it.

>
>Any help would be appreciated ASAP!
>
>Brian
>
>PS.
>What I need to see back from the query is:
>
>Available Capacity
>
>900 5000
>

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jul 23 1997 - 00:00:00 CDT