Grouping and Summarization


func.first

This function returns the value of a specified field in the first record of the result set returned by a query

func.last

This function returns the value of a specified field in the last record of the result set returned by a query

func.max

The MAX function is an aggregate function that returns the maximum value in a set of values

func.median

Thia function will calculate the middle value of a given set of numbers

func.stdev

The STDEV function calculates the standard deviation for a sample set of data

func.stdev_pop

STDDEV_POP computes the population standard deviation and returns the square root of the population variance

func.stdev_samp

STDDEV_SAMP() function returns the sample standard deviation of an expression

func.var_pop

VAR_POP returns the population variance of a set of numbers after discarding the nulls in this set

func.var_samp

VAR_SAMP returns the sample variance of a set of numbers after discarding the nulls in this set

func.variance

This function is used to determine how far a set of values is spread out based on a sample of the population

Last modified December 20, 2022 at 10:05 AM EST: remove sitemap priority (56709da)