Oracle Aggregate Function Example

Next »

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

Next »