| Function |
Description |
| ARRAY_AGG |
Aggregates a set of elements into an array. |
| AVG |
Returns the average of a set of numbers. |
| CORRELATION |
Returns the coefficient of correlation of a set of number pairs. |
| COUNT |
Returns the number of rows or values in a set of rows or values. |
| COUNT_BIG |
Returns the number of rows or values in a set of rows or values.
The result can be greater than the maximum value of INTEGER. |
| COVARIANCE |
Returns the covariance of a set of number pairs. |
| COVARIANCE_SAMP |
Returns the sample covariance of a set of number pairs. |
| CUME_DIST |
Returns the cumulative distribution of a row that is hypothetically inserted into a group of rows. |
| GROUPING |
Used with grouping-sets and super-groups to indicate sub-total rows generated by a grouping set.
The value returned is 0 or 1.
A value of 1 means that the value of the argument in the returned row is a null value, and the row was generated for a grouping set.
This generated row provides a sub-total for a grouping set. |
| LISTAGG |
Aggregates a set string elements into one string by concatenating the strings. |
| MAX |
Returns the maximum value in a set of values. |
| MEDIAN |
Returns the median value in a set of values. |
| MIN |
Returns the minimum value in a set of values. |
| PERCENTILE_CONT |
Returns the value that corresponds to the specified percentile, given a sort specification by using a continuous
distribution model. |
| PERCENTILE_DISC |
Returns the value that corresponds to the specified percentile given a sort specification by using a discrete distribution model. |
| PERCENT_RANK |
Returns the relative percentile rank of a row that is hypothetically inserted into a group of rows. |
Regression functions (REGR_AVGX,
REGR_AVGY, REGR_COUNT, ...) |
The regression functions fit an ordinary-least-squares regression line of the form y = a * x + b to a set of number pairs:
- REGR_AVGX returns quantities used to compute diagnostic statistics.
- REGR_AVGY returns quantities used to compute diagnostic statistics.
- REGR_COUNT returns the number of non-null number pairs used to fit the regression line.
- REGR_INTERCEPT or REGR_ICPT returns the y-intercept of the regression line.
- REGR_R2 returns the coefficient of determination for the regression.
- REGR_SLOPE returns the slope of the line.
- REGR_SXX returns quantities used to compute diagnostic statistics.
- REGR_SXY returns quantities used to compute diagnostic statistics.
- REGR_SYY returns quantities used to compute diagnostic statistics.
|
| STDDEV |
Returns the biased standard deviation (division by n) of a set of numbers. |
| STDDEV_SAMP |
Returns the sample standard deviation (division by [n-1]) of a set of numbers. |
| SUM |
Returns the sum of a set of numbers. |
| VARIANCE |
Returns the biased variance (division by n) of a set of numbers. |
| VARIANCE_SAMP |
Returns the sample variance (division by [n-1]) of a set of numbers. |
| XMLAGG |
Returns an XML sequence containing an item for each non-null value in a set of XML values. |
| XMLGROUP |
Returns an XML value with a single XQuery document node containing one top-level element node. |
