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 -> Re: SQL Question using MAX()

Re: SQL Question using MAX()

From: P. Larsen <plarsen_at_dc.dynares.com>
Date: Thu, 19 Nov 1998 13:17:26 -0500
Message-ID: <731o1u$4uj3@news.uscg.mil>


Try:
select area, length
from <table>
where length in (select max(length) from <table>);

Dave Klinger wrote in message <36545CB4.B5D25F0F_at_bechtel.com>...
>I have a table which has multiple records for a given area, with
>multiple areas. I want to know the area that has the maximum total
>length. Example data:
>
>area length
>---- ------
>7511 42.1
>7511 22.6
>7512 12.5
>7512 10.1
>7512 11.3
>7513 19.2
>
>Result should be:
>
>area sum(length)
>----- -----------
>7511 64.7
>
>I tried using the max() function, but when I do that I can only get back
>the maximum value, but I don't know what area that value goes to.
>Anyone have any ideas?
>
>Thanks,
>Dave
>
Received on Thu Nov 19 1998 - 12:17:26 CST

Original text of this message

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