In article <5r5ust$64a$2_at_gte1.gte.net>, cnsltwlh_at_GeeTeeEee.net says...
>
>select a.available, a.capacity from table_a a
>where a.route = 11 and
>a.available = (select min(b.available) from table_a b
> where b.route = a.route);
>
>In article <869684186.30768_at_dejanews.com>, sgulukot_at_bbnplanet.com says...
>>
>>Try this query
>>
>>Select available, capacity
>>from table_a
>>where available = (select min(available)
>> from table_a);
>>
>>This query will return all the rows that have minimum available. Where
>>clause on route depends on whether you want it.
>>
>>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
>>);
>>
>>-------------------==== Posted via Deja News ====-----------------------
>> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Wed Jul 23 1997 - 00:00:00 CDT
