AVG(expr)
AVG(expr)
Calculates the average of the given expression
expr over the specified window frameCOUNT(expr)
COUNT(expr)
Calculates the count of the given expression
expr over the specified window frameMAX(expr)
MAX(expr)
Calculates the maximum value of the given expression
expr over the specified window frameMEAN(expr)
MEAN(expr)
Alias for
AVG(). Calculates the average of the given expression expr over the specified
window frameMIN(expr)
MIN(expr)
Calculates the minimum value of the given expression
expr over the specified window framePRODUCT(expr)
PRODUCT(expr)
Calculates the product of the given expression
expr over the specified window frameRATIO_TO_REPORT(expr)
RATIO_TO_REPORT(expr)
Calculates the ratio of the value of
expr to the sum of expr over the specified window
frame. Note that ORDER BY is not supported for this function.STDDEV(expr)
STDDEV(expr)
Alias for
STDDEV_POP(). Calculates the population standard deviation of the given
expression expr over the specified window frameSTDDEV_POP(expr)
STDDEV_POP(expr)
Calculates the population standard deviation of the given expression
expr over the specified
window frameSTDDEV_SAMP(expr)
STDDEV_SAMP(expr)
Calculates the sample standard deviation of the given expression
expr over the specified
window frameSUM(expr)
SUM(expr)
Calculates the sum of the given expression
expr over the specified window frameVAR(expr)
VAR(expr)
Alias for
VAR_POP(). Calculates the population variance of the given expression expr over
the specified window frameVAR_POP(expr)
VAR_POP(expr)
Calculates the population variance of the given expression
expr over the specified window
frameVAR_SAMP(expr)
VAR_SAMP(expr)
Calculates the sample variance of the given expression
expr over the specified window frame