func.first
This function returns the value of a specified field in the first record of the result set returned by a query
Grouping and Summarization
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)