SQL SUM() Function

 The SUM() function in SQL is used to calculate the total sum of a numeric column. It is commonly used with the SELECT statement and often in conjunction with the GROUP BY clause to summarize data.

Syntax:

SELECT SUM(column_name)
FROM table_name
WHERE condition;

Key Points:

1. The SUM() function works on numeric data types.
2. It ignores NULL values in the column during the calculation.
3. You can use it with GROUP BY to calculate sums for different groups in a dataset.

Examples:

Example 1: Basic Usage

Suppose you have a table named Sales:

SaleID	Amount
1	100
2	200
3	150
4	NULL

To calculate the total sales amount:

SELECT SUM(Amount) AS TotalSales
FROM Sales;

Result:

TotalSales
450

Example 2: Using SUM() with GROUP BY

If you have an additional column, Region:

SaleID	Amount	Region
1	100	North
2	200	South
3	150	North
4	NULL	South

To calculate the total sales for each region:

SELECT Region, SUM(Amount) AS TotalSales
FROM Sales
GROUP BY Region;

Result:

Region	TotalSales
North	250
South	200

Example 3: Using SUM() with HAVING

You can filter grouped results using the HAVING clause:

SELECT Region, SUM(Amount) AS TotalSales
FROM Sales
GROUP BY Region
HAVING SUM(Amount) > 200;

Result:

Region	TotalSales
North	250

The SUM() function is a powerful tool for aggregating numeric data in SQL queries. Let me know if you'd like more detailed examples!