How to Calculate Average in Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

AVG function is to calculate the average in Oracle.

Syntax

AVG function takes an aggregate expression as an argument and returns average value.

AVG (aggregate expression)

AVG Function Example

The following example will calculate the average salary by the department from the EMP table.

 SELECT deptno, AVG (sal)
FROM emp
GROUP BY deptno;

Output

DEPTNO AVG(SAL)
---------- ----------
30         1566.66667
20         2175
10         2743

See also: