Home  >  Article  >  Database  >  What are MySQL group functions?

What are MySQL group functions?

PHPz
PHPzforward
2023-08-24 11:53:021097browse

MySQL 组函数是什么?

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!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete