AVG()
This function returns the average of the values in a group
COUNT()
This function returns the number of items found in a group.
MAX()
Returns the maximum value in the expression.
MIN()
Returns the minimum value in the expression
STDEV()
Returns the statistical standard deviation of all values in the specified expression.
STDEVP()
Returns the statistical standard deviation for the population for all values in the specified expression.
SUM()
Returns the sum of all the values, or only the DISTINCT values, in the expression.
VAR()
Returns the statistical variance of all values in the specified expression
VARP()
Returns the statistical variance for the population for all values in the specified expression.
Common Syntax
window_function ( [ ALL ] expression ) OVER ( [ PARTITION BY expr_list ] [ ORDER BY order_list frame_clause ] )
Leave a Reply