MSSQL - How to sum each column values

Watch this example on YouTube




 SELECT        Qty, Price
FROM            Orders
UNION ALL
SELECT        SUM(Qty) AS Expr1, SUM(Price) AS Expr2
FROM            Orders