SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Nested Group Function without Group By Problem

810989Nov 6 2010 — edited Nov 6 2010

Hey everyone,

I have 3 tables as below:

TABLES

ITEM (Item_no, Item_price, desc)
DeliveryItem (delivery_no, item_no, quantity)
Delivery (delivery_no, delivery_date)

SELECT desc, MAX(SUM(quantity)) FROM DeliveryItem, Item, Delivery WHERE Item.item_no = DeliveryItem.item_no AND Delivery.delivery_no = deliveryitem.delivery_no;

And I'm trying to output description of most delivered item but I got an error like SQL Error: ORA-00978: nested group function without GROUP BY. Could you help me to fix my code?

Thanx

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2010

Added on Nov 6 2010

5 comments

11,853 views