AVG « Aggregate Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Aggregate Functions
  3. AVG
12.2.AVG
12.2.1.AVG(x) gets the average value of x.
12.2.2.Use AVG
12.2.3.List the employees whose salary is higher than the average salary with subquery
12.2.4.Using avg() function in having clause
12.2.5.Count department and calculate average salary
12.2.6.Greater than average salary