Aggregate Functions
Aggregate
functions operate on a set of data. These are usually used to perform
some action on a complete set of returned rows. For example,
SELECT
AVG(height) FROM kids
would return the average of all the values of the
height
field in the kids
table.

AVG(
expression
)
Returns the average value of the values in
expression
(e.g.,SELECT AVG(score)
FROM tests
).
BIT_AND(
expression
)
Returns the bitwise
AND
aggregate of all the values inexpression
(e.g.,SELECT
BIT_AND(flags) FROM options
). A bit will be set in the result if and only if the bit is set in every input field.
BIT_OR(
expression
)
Returns the bitwise
OR
aggregate of all the values inexpression
(e.g.,SELECT
BIT_OR(flags) FROM options
). A bit is set in the result if it is set in at least one of the input fields.
COUNT(
expression
)
Returns the number of times
expression
was not null.COUNT(*)
will return the number of rows with some data in the entire table (e.g.,SELECT
COUNT(*)
FROM
folders
).
MAX(
expression
)
Returns the largest value in
expression
(e.g.,SELECT
MAX
(elevation)
FROM mountains
).
MIN(
expression
)
Returns the smallest value in
expression
(e.g.,SELECT
MIN(level)
FROM
toxic_waste
).
STD(
expression
)/STDDEV(
expression
) Returns the standard deviation of the values in
expression
(e.g.,SELECT
STDDEV(points) FROM data
).
SUM(
expression
)
Returns the sum of the values in
expression
(e.g.,SELECT SUM(calories) FROM
daily_diet
).
Get Managing & Using MySQL, 2nd Edition now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.