sql - 如何使用聚合函数sql server选择列

Question

我需要选择两列。1。计算一列的总和并显示它 2.按原样显示列。所以我尝试了下面的代码

SELECT Sum(CONVERT(FLOAT, Replace(total, Char(0), ''))) AS Total, 
       [product name] 
FROM   tb_sales_entry_each_product 
GROUP  BY [sales date] 

错误信息

Column 'tb_sales_entry_each_product.Product Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

我在哪里犯了错误。谢谢

Answer 1

只需分组

select SUM(CONVERT(float, REPLACE(Total, CHAR(0), ''))) as Total, [Product Name]  
from tb_sales_entry_each_product group by [Sales Date], [product name]

每当您进行数字计数和等时，任何其他列都需要进行分组。这就是你所缺少的一切