Course Process
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.