"if you encounter any errors in SAP, send me a screenshot at pramod@learntosap.com, and I will help you resolve the issue."

SQL SUM() Function

SQL TUTORIALS-

SQL SUM() Function

Introduction-

-✅SUM() function adds up all the numeric values in a specified column...

Emoji Examples in HTML

🔸 Example Table: Orders

OrderID	Customer	Product	Quantity	Price
1	ANNI	Mobile	1	30000
2	POOJA	Laptop	1	35000
3	RAJ	Tablet	1	40000



SELECT SUM(Price) AS TotalSales FROM Orders;

✅Result Show :-

TotalSales → 105000 |



SELECT SUM(Quantity) AS TotalQuantity FROM Orders;

✅Result Show :-

TotalQuantity → 3 |



SELECT Product, SUM(Price) AS ProductSales
FROM Orders
GROUP BY Product;

✅Result Show :-

Emoji Examples in HTML



SELECT Customer, SUM(Price) AS CustomerSpending
FROM Orders
GROUP BY Customer;