func.avg
This function returns the average of the values in a group. It ignores null values
Window Functions
func.count
An aggregate function that returns the number of rows, or the number of non-NULL rows
func.cume_dist
This function calculates the cumulative distribution of a value within a group of values
func.dense_rank
The DENSE_RANK() is a window function that assigns a rank to each row within a partition of a result set
func.first_value
FIRST_VALUE is an analytic function. It returns the first value in an ordered set of values
func.lag
This analytic function lets you query more than one row in a table at a time without having to join the table to itself
func.last_value
The LAST_VALUE() function is a window function that returns the last value in an ordered partition of a result set
func.lead
This analytic function provides access to more than one row of a table at the same time without a self join
func.min
The min() function returns the item with the lowest value, or the item with the lowest value in an iterable
func.ntile
This is a function that distributes rows of an ordered partition into a specified number of approximately equal groups, or buckets
func.percent_rank
The PERCENT_RANK() function evaluates the relative standing of a value within a partition of a result set
func.rank
This is a function that assigns a rank to each row within a partition of a result set
func.row_number
This function is used to provide consecutive numbering of the rows in the result by the order selected in the OVER clause for each partition
func.sum
The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three
Last modified December 20, 2022 at 10:05 AM EST: remove sitemap priority (56709da)