SQL Oracle Java JSP JDBC PHP MORE

Oracle Query for SUM

❮ Previous Next ❯

The Oracle SUM() function is used to calculate sum of numbers.

Oracle SUM() Syntax

SELECT SUM(column_name)
FROM table_name
WHERE condition;

Oracle SUM() Example

In this example we calculate the average run of Virat kohili in 3 match.

MatchNo	Name	Run	Wicket
1	Virat	78	1
2	Virat	82	2
3	Viart	50	0

Oracle Query

SELECT SUM(Run)
FROM cricket_score;

Output

210

❮ Previous Next ❯