SQL Oracle PHP Java JSP JDBC MORE

SQL Query for Calculate Average

❮ Previous Next ❯

The SQL AVG() function is used to calculate average of numbers.

SQL AVG() Syntax

SELECT AVG(column_name)
FROM table_name
WHERE condition;

SQL AVG() 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

SQL Query

SELECT COUNT(Run)
FROM students_data;

Output

70.00

❮ Previous Next ❯