Group by two columns and display grand total in every row

group-by, sql, sql-server, sum

Solution

Please try:

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

Problem

Below are the list data. ``` 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 ``` 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. Is this possible? ``` Code ItemCount Type Amount ---------------------------------------- B001 2 Dell 20.00 B001 5 Apple 50.00 B114 2 Apple 40.50 ```

Original source