Aggregate functions summarize the values in a column. Below are some examples of aggregate functions that can be used when retrieving data from an Oracle database. Please see the documentation for your own database for more information.
Note: The following functions only apply to data retrieved from an Oracle database:
Function |
Description |
SUM (%1) |
total of all the rows in column %1, given that the column is numeric |
AVG (%1) |
average of column %1 |
MAX (%1) |
largest figure in column %1 |
MIN (%1) |
smallest figure in column %1 |
COUNT(%1) |
number of rows in column %1 |
CORR(%1,%2) |
coefficient of correlation of columns %1 and %2 |
COVAR_POP(%1,%2) |
population covariance of columns %1 and %2 |
COVAR_SAMP(%1,%2) |
sample covariance of columns %1 and %2 |
REGR_SLOPE(%1,%2) |
slope of the line described by columns %1 and %2 |
REGR_INTERCEPT(%1,%2) |
y-intercept of the regression line described by columns %1 and %2 |
REGR_COUNT(%1,%2) |
integer that is the number of non-null number pairs used to fit the regression line |
REGR_R2(%1,%2) |
coefficient of determination (also called "R-squared" or "goodness of fit") for the regression |
REGR_AVGX(%1,%2) |
average of the independent variable (%2) of the regression line |
REGR_AVGY(%1,%2) |
average of the dependent variable (%1) of the regression line |
REGR_SXX(%1,%2) |
computed as: |
REGR_SYY(%1,%2) |
computed as: |
REGR_SXY(%1,%2) |
computed as: |
STDDEV(%1) |
sample standard deviation of column %1 |
STDDEV_POP(%1) |
computes the population standard deviation of column %1 and returns the square root of the population variance |
STDDEV_SAMP(%1) |
computes the cumulative sample standard deviation of column %1 and returns the square root of the sample variance |
VAR_POP(%1) |
population variance of column %1 |
VAR_SAMP(%1) |
sample variance of column %1 |
VARIANCE(%1) |
variance of column %1 |
See also: