MySQL Aggregate functions

MySQL Aggregate functions

I. AVG

AVG (col)

Returns the average value of a specified column.

Ii. COUNT

COUNT (col)

Returns the number of non-NULL values in the specified column.

3. MIN/MAX

MIN (col): returns the minimum value of a specified column.

MAX (col): returns the maximum value of a specified column.

Iv. SUM

SUM (col)

Returns the sum of all values of a specified column.

5. GROUP_CONCAT

GROUP_CONCAT ([DISTINCT] expr [, expr...]
[Order by {unsigned_integer | col_name | expr}
[ASC | DESC] [, col_name...]
[SEPARATOR str_val])

Returns the result of a combination of column values.

SELECT id,GROUP_CONCAT(name) FROM my_table GROUP BY id;SELECT id,GROUP_CONCAT(name separator ';') FROM my_table GROUP BY id;SELECT id,GROUP_CONCAT(name order by id) FROM my_table GROUP BY id;SELECT id,GROUP_CONCAT(name order by id separator ';') FROM my_table GROUP BY id;

The above is a detailed explanation of all the MySQL common Aggregate functions provided by Alibaba Cloud ~