首页 文章

在多个列的选择中求和1列

提问于
浏览 次
0

我试图在我的选择查询中加上（）数量字段按日期值对它们进行分组但是Sql继续给我错误，说不是列在我的GroupBy中分组但我只想要按日期对它们进行分组

这是我的查询：

SELECT   Date, Clave_PDV, Che, Lin, Dish, Dish_Name, Type, 
sum(Quantity) as Quant, Price, Total, Tur, Tur_Name, Group, 
Group_Name, Pdv_Name, St_Pla, St_Che
FROM  Dish_Sales
GROUP BY Date

如何按日期汇总（数量）？

sql group-by sum

2 回答

  • 2

    您将删除不需要的所有列：

    SELECT Date, sum(Quantity) as Quant
FROM Dish_Sales
GROUP BY Date;
    回复于
  • 1

    如果你想要按日期求和，你应该我们

    SELECT   Date, sum(Quantity) as Quant
FROM  Dish_Sales
GROUP BY Date

    否则，您应该对所有未聚合的列使用group by

    SELECT   Date, Clave_PDV, Che, Lin, Dish, Dish_Name, Type, 
sum(Quantity) as Quant, Price, Total, Tur, Tur_Name, Group, 
Group_Name, Pdv_Name, St_Pla, St_Che
FROM  Dish_Sales
GROUP BY Date, Clave_PDV, Che, Lin, Dish, Dish_Name, Type, 
     Price, Total, Tur, Tur_Name, Group, 
      Group_Name, Pdv_Name, St_Pla, St_Che
    回复于

相关问题