PL/SQL Avg

Oracle PL/SQL Avg Function

The Avg function returns the average value of an expression.

The Avg Function syntax:

Select avg(exp) From table Where condition ;

Example 1:

Select avg(e.sal) 
From emp e 
Where e.job='CLERK' ;

Example 2:

Select e.deptno, avg(e.comm) 
From emp e 
Group By e.deptno ;