AVG(expression) : Returns average value of expression
CORR(expression1, expression2) : Returns the coefficient of correlation of a set of number pairs
COVAR_POP(expression1, expression2) : Returns the population covariance of a set of number pairs
COVAR_SAMP(expression1, expression2) : Returns the sample covariance of a set of number pairs
CUME_DIST(expression1, ...) : Calculates the cumulative distribution of a value in a group of values
DENSE_RANK() : Computes the rank of a row in an ordered group of rows and returns the rank as a number
FIRST_VALUE(expression) : Returns the first value in an ordered set of values
LAG(expression, offset, ...) : Provides access to a row at a given physical offset prior to cursor position
LAST_VALUE(expression) : Returns the last value in an ordered set of values
LEAD(expression, offset, ...) : Provides access to a row at a given physical offset beyond cursor position
MAX(expression) : Returns maximum value of expression
MIN(expression) : Returns minimum value of expression
NTILE(expression) : Divides an ordered data set into a number of buckets indicated by expression and assigns the appropriate bucket number to each row
PERCENT_RANK(expression1, ...) : For a row r, PERCENT_RANK calculates the rank of r minus 1, divided by 1 less than the number of rows being evaluated
PERCENTILE_CONT(expression) : Takes a percentile value and a sort specification, and returns an interpolated value that would fall into that percentile value
PERCENTILE_DISC(expression) : Takes a percentile value and a sort specification, and returns an element from the set
RANK(expression1, ...) : Computes the rank of each row returned from a query with respect to the other rows returned by the query
RATIO_TO_REPORT(expression) : Computes the ratio of a value to the sum of a set of values
REGR_SLOPE(expression1, expression2) : Returns the slope of the line
REGR_INTERCEPT(expression1, expression2) : Returns the y-intercept of the regression line
REGR_COUNT(expression1, expression2) : Returns an integer that is the number of non-null number pairs used to fit the regression line
REGR_R2(expression1, expression2) : Returns the coefficient of determination (also called R-squared or goodness of fit) for the regression
REGR_AVGX(expression1, expression2) : Evaluates the average of the independent variable (expression2) of the regression line
REGR_AVGY(expression1, expression2) : Evaluates the average of the independent variable (expression1) of the regression line
ROW_NUMBER() : Assigns a unique number to each row to which it is applied
STDDEV(expression) : Returns the sample standart deviation of expression, a set of numbers
STDDEV_POP(expression) : Computes the population standart deviation and returns the square root of the population variance
STDDEV_SAMP(expression) : Computes the cumulative sample standart deviation and returns the square root of the sample variance
SUM(expression) : Returns the sum of values of expression
VAR_POP(expression) : Returns the population variance of a set of numbers
VAR_SAMP(expression) : Returns the sample variance of a set of numbers
Comments
Post a Comment