在多个列的选择总和1列
问题描述:
我试图sum()我的选择查询按日期值分组它们的数量字段,但Sql不断给我的错误,说没有AL列分组在我的GroupBy,但我只想O基团并按照时间在多个列的选择总和1列
这是我的查询:
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
我怎么能总和(数量)的日期将它们分组?
答
你会删除所有你不想要的列:
SELECT Date, sum(Quantity) as Quant
FROM Dish_Sales
GROUP BY Date;
答
如果你想通过日期之应我们发
SELECT Date, sum(Quantity) as Quant
FROM Dish_Sales
GROUP BY Date
否则,你应该为所有列使用该组未汇总
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
'我只想按日期对它们进行分组,那么您应该如何选择'Che'或'Lin'的值,fo实例? – Lamak
显示不属于聚集的列是没有意义的。在这种情况下显示哪一行? – Eric