Chapter 7. Mathematical and Aggregate Functions
MySQL has many built-in mathematical and aggregate functions that you can use in SQL statements for performing calculations on values in databases. Functions in this chapter include those used for statistical information, such as counting rows and determining the average of a given column’s value.
You should
be aware of a few factors regarding some of these functions: all
mathematical functions return NULL when there is an error. If an
aggregate function is used without a GROUP BY
clause, it operates on all rows. The following aggregate functions
require a GROUP BY
clause: AVG()
, BIT_AND( )
, BIT_OR(
)
, BIT_XOR( )
, COUNT()
, GROUP_CONCAT( )
, MIN(
)
, MAX( )
, STD( )
,
STDDEV( )
, SUM( )
,
VARIANCE( )
.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.