Oracle Analytics Function List sharing

SUM: The function calculates the accumulation of expressions in a group and

Min: Find the minimum value of an expression in a data window in a group

Max: Find the maximum value of an expression in a data window in a group

AVG: Used to calculate the average of an expression within a group and data window.

Count: Accumulate a count of what is happening within a group

RANK: calculates the relative position of the other rows from each row returned by the query, based on the value of the expression in the ORDER by clause

Dense_rank: calculates the relative position of each row that is returned from the query, based on the value of the expression in the ORDER by clause

First: Remove the row from the first value in the collection returned from Dense_rank

Last: Takes a row from the collection returned by Dense_rank to a value in the final row

First_value: Returns the first value of the Data window in a group

Last_value: Returns the last value of the data window in the group.

LAG: You can access other rows in the result set without having to self-connect

Lead: Leadsand lags instead, leadscan access rows after the current row in the group

Row_number: Returns the offset of a row in an ordered group so that it can be used for line numbers sorted by specific criteria

STDDEV: Calculates the current row about the standard deviation of the group

Stddev_pop: The function calculates the overall standard deviation and returns the square root of the population variable

Stddev_samp: The function calculates the cumulative sample standard deviation and returns the square root of the population variable

Var_pop: The function returns the population variable of a non-empty collection (ignoring null)

Var_samp: The function returns a sample variable for a non-empty collection (ignores null)

VARIANCE: Returns 0 if the number of rows in the expression is 1, or var_samp If the number of rows in the expression is greater than 1

Covar_pop: Returns the population covariance of a pair of expressions

Covar_samp: Returns the sample covariance of a pair of expressions

CORR: Returns the correlation coefficient of a pair of expressions

Cube: According to the OLAP cube method of data statistics , that each dimension is required to statistics

Oracle Analytics Function List sharing