Home » SQL & PL/SQL » SQL & PL/SQL » select max of sums
select max of sums [message #591] Fri, 22 February 2002 16:23 Go to next message
Robert Mark Bram
Messages: 3
Registered: February 2002
Junior Member
Howdy all!

Let's say we have a product orders table like this:

SQL> select * from orders;

ORDER_NO PROD_NO QUANTITY
--------- --------- ---------
1 2 3
2 2 3
3 3 3
4 1 4
5 3 8
6 2 7
7 1 6
8 1 3
9 3 3
10 2 4

10 rows selected.

SQL>

I want to select the prod_no and sum (quantity) for the product with the max sum
(quantity).

I have this so far:

SQL> select
2 max (sumamt) as maximum
3 from
4 (select
5 sum (orders.quantity) as sumamt
6 from
7 orders
8 group by
9 orders.prod_no);

MAXIMUM
---------
17

SQL>

But how can I get the matching prod_id?

Any help would be much appreciated!

Rob
Re: select max of sums [message #592 is a reply to message #591] Fri, 22 February 2002 19:21 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select
2 max (sumamt) as maximum
3 from
4 (select
5 sum (orders.quantity) as sumamt
6 from
7 orders
8 group by
9 orders.prod_no);
Previous Topic: hi suresh .. data base link
Next Topic: Re: select max of sums
Goto Forum:
  


Current Time: Mon Sep 27 18:09:37 CDT 2021