PL/SQL Sum

The Sum function returns the summed value of an table column or expression.

Sum syntax

select sum(expression) from table;

Sum example

COURSE_ID	NAME	DESCRIPTION	DURATION	PRICE
1	SQL 1	SQL course for beginners	1 week	10
2	SQL 2	SQL course for advanced	2 week	50
3	HTML5	Learn HTML 5	1 week	10
4	PHP	PHP course	4 week	75
5	CSS	Learn CSS	2 week	20

select sum(price) from course;

Result: 165


select sum(price*2) from course;

Result: 330


select sum(price) from course where price between 20 and 50;

Result: 70


select course_id, name, price,
sum(decode(price, 10, price*3, 20, price*4)) mysum 
from course 
where price < = 20
group by course_id, name, price
order by course_id;

COURSE_ID	NAME	PRICE	MYSUM
1	SQL 1	10	30
3	HTML5	10	30
5	CSS	20	80

↑