按两列分组并在每一行显示总计 [英] Group by two columns and display grand total in every row

问题描述

以下是列表数据.

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

这篇关于按两列分组并在每一行显示总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！