Aggregate Functions Basics « Aggregate Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Aggregate Functions
  3. Aggregate Functions Basics
1.Use the aggregate functions with any valid expression
2.Order by the result of aggregate function
3.In Oracle, nulls in calculations involving aggregate functions are ignored
4.Limit the rows passed to the aggregate function using a WHERE clause
5.Combine the max and avg function together
6.Retrieves the city and average salary of the employees grouped by city
7.Having with aggregate function
8.Aggregate function and alias column name