SUM Function

The SUM() function returns the total sum of a numeric column.

Syntax:

SELECT SUM(column_name)
FROM table_name
WHERE condition;

Query:

SELECT sum(salary) FROM `salaries`

Output:

Tester Usage Tips:

• Validate Pivot reports sum total
• Validate Dashboard KPI (Key performance indicators) like Total Sales, Total Customers etc.