Window Functions


func.avg

This function returns the average of the values in a group. It ignores null values

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)