NOT a group by expression SQL

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

score 2 · Answer 1 · answered Aug 03 '14 at 10:27

2

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

answered Aug 03 '14 at 10:27

Michael Green

1,397
1
17
25

1

that means i need to add f.FoodName in the group by clause also ? – user3903563 Aug 03 '14 at 10:35
1

Yes you should add that column to the group by. – Michael Green Aug 03 '14 at 10:53

score 0 · Accepted Answer · answered Aug 03 '14 at 10:35

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 03 '14 at 10:35

Walter Mitty

18,205
2
28
58

NOT a group by expression SQL

2 Answers2