Urgent help on SQL

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