Oracle Aggregate Function Example






Oracle/PLSQL AVG Calculates the average
Oracle/PLSQL COUNT(x) Returns the number of rows returned by a query involving x
Oracle/PLSQL FIRST Get the first in the group
Oracle/PLSQL LAST Get the last in the group
Oracle/PLSQL MAX Get the max in the group
Oracle/PLSQL MEDIAN Returns the median value
Oracle/PLSQL MIN Get the min value in the group
Oracle/PLSQL RATIO_TO_REPORT
Oracle/PLSQL STDDEV Returns the standard deviation
Oracle/PLSQL SUM Sum the group
Oracle/PLSQL VARIANCE Returns the variance