NOT a group by expression SQL [duplicate]

Question

create view top5food as
select f.FoodID,f.FoodName,SUM(o.Quantity) as "Total Food Sold"
from  FOODANDBEVERAGEORDER o,FOODANDBEVERAGE f
where o.foodid=f.foodid
group by o.foodid
order by SUM(o.Quantity) desc;

anything wrong with this query? there is an error ORA-00979 NOT A GROUP BY EXPRESSION

Michael Green · Accepted Answer · 2014-08-03 10:27:59Z

2

You have f.FoodName in the select list but it is not in the group by clause.

answered Aug 3, 2014 at 10:27

Michael Green

1,5011 gold badge19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

user3903563 Over a year ago

that means i need to add f.FoodName in the group by clause also ?

Michael Green Over a year ago

Yes you should add that column to the group by.

Walter Mitty · Accepted Answer · 2014-08-03 10:35:30Z

0

create view top5food as
select f.FoodID,f.FoodName,SUM(o.Quantity) as "Total Food Sold"
from  FOODANDBEVERAGEORDER o,FOODANDBEVERAGE f
where o.foodid=f.foodid
group by f.FoodID, f.FoodName
order by SUM(o.Quantity) desc;

answered Aug 3, 2014 at 10:35

Walter Mitty

19k2 gold badges32 silver badges62 bronze badges

Collectives™ on Stack Overflow

NOT a group by expression SQL [duplicate]

2 Answers 2

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related