对行求和，得到表中的列

Question

我有一个这样的表:

No_Peanut2.40

Answer 1

创建独立的表

SELECT Product, SUM(Price) AS Total_price 
INTO schema.newtable FROM schema.ProductTable
Group by Product;

Answer 2

这是一个简单的聚合:

select prodct, sum(price) as total_price
from products
group by product
order by product;

结果是一个表。只是它不是存储在数据库中的表。通常不希望存储这样一个额外的表，因为这样您的数据库中就会有冗余的信息，这可能会导致以后的不一致。

但是如果你愿意，你可以使用上面的查询来创建一个表:

create new_table as选择product, sum(price)作为total_price从产品

Update: SQL Server不支持从查询中创建表的标准SQL语法。SQL Server中的语法是:

select prodct, sum(price) as total_price
into new_table
from products
group by product;

Answer 3

查询只是一个简单的GROUP BY:

SELECT Product, SUM(Price) AS Total_price
FROM Table1
GROUP BY Product;

如果您想将它插入到一个已经存在的单独的表中，只需将insert与该查询结合使用:

INSERT Table2 (Product, Total_price)
SELECT Product, SUM(Price) AS Total_price
FROM Table1
GROUP BY Product;

或者，动态创建一个新表:

SELECT Product, SUM(Price) AS Total_price
INTO Table2
FROM Table1
GROUP BY Product;