Question

此选择语句给出的数数 :

- 同样的阴道

- 同样的猫Name

但有不同的销售额

Select p.CatCode, p.CatName, s.Sales_Amt
From A3_Dw_Prod p, A3_Dw_Sales s
Order By p.Dw_Prod_Id Desc;

I would Like to use Sum Function to add the these Categories and Group Them When I use Sum I get an Error

ORA-00979:不是按表达方式划分的组别

Select p.CatCode, p.CatName, Sum(s.Sales_Amt)
From A3_Dw_Prod p, A3_Dw_Sales s
Where p.Dw_Prod_Id = s.Dw_Prod_Id
Group By p.CatCode, p.CatName 
Order By p.Dw_Prod_Id Desc;

Answer 1

我认为p.Dw_Prod_Id Desc专栏不是按条款排列的。

Answer 2

I think the problem arises as you have included the " p.Dw_Prod_Id" in the ORDER BY clause However, this column has not been selected in the main query so it creates problem Put in ORDER BY one of the columns that is in the select clause(p.CatCode, p.CatName)

Answer 3

您必须同时将您正在按 OR 条令分组使用的列进行选择。

Select p.CatCode, p.CatName, p.Dw_Prod_Id, Sum(s.Sales_Amt)
From A3_Dw_Prod p, A3_Dw_Sales s
Where p.Dw_Prod_Id = s.Dw_Prod_Id
Group By p.CatCode, p.CatName,p.Dw_Prod_Id
Order By p.Dw_Prod_Id Desc, p.CatCode, p.CatName;

友情链接