按两列分组并在每一行显示总计

2021-12-27 00:00:00 sql sum group-by sql-server

以下是列表数据.

Code   ItemCount   Type      Amount 
----------------------------------------
B001    1          Dell         10.00
B001    1          Dell         10.00
B001    1          Apple        10.00
B001    2          Apple        20.00
B001    2          Apple        20.00
B114    1          Apple        30.50
B114    1          Apple        10.00

我需要一个结果来按代码和类型分组并合计 ItemCount 并获得每一行中 Amount 的总计.

I need a result to group by code and by type and total the ItemCount and get the grand total of the Amount in every row.

这可能吗?

Code   ItemCount    Type      Amount 
----------------------------------------
B001    2          Dell          20.00
B001    5          Apple         50.00
B114    2          Apple         40.50

推荐答案

请尝试:

SELECT
    Code,
    SUM(ItemCount) ItemCount,
    Type,
    SUM(Amount) Amount
FROM
    YourTable
GROUP BY Code, Type
ORDER BY Code

相关文章