What are MySQL group functions?

A group function is a function that is applied to a group of rows, in other words, a group function operates on a group of values. The following table gives a description of the MySQL group functions -

##1234 567891011121314151617

Mr. No.	Name and Description
	AVG()Returns the average value of the parameters.
	BIT_AND() Returns the bitwise AND.
	BIT_ORIt returns a bitwise OR.
	BIT_XOR()Returns bitwise XOR.
	COUNT()It returns the number of rows returned.
	COUNT(DISTINCT)Returns the count of numeric distinct values.
	GROUP_CONCAT()It returns a connection string. p>
	MAX()It returns the maximum value. p>
	MIN()It returns the minimum value. p>
	ST()It returns the population standard deviation.
	STDDEV()It returns the population standard deviation.
	STDDEV_POP()It returns the population standard deviation.
	STDDEV_SAMP()It returns the sample standard deviation.
	SUM()It returns the sum.
	VAR_POP()It returns the population standard deviation.
	VAR_SAMP()It returns the sample variance. p>
	Variance()It returns the population standard deviation.

The above is the detailed content of What are MySQL group functions?. For more information, please follow other related articles on the PHP Chinese website!