Database Reference
In-Depth Information
Chapter 12. Aggregate and Numeric
Functions
Databases will always include numbers: there's always something to value, count, or calcu-
late. And you may want to round the results from those numbers to conform to personal
preferences. There are numeric and arithmetic functions to do these things in MySQL and
MariaDB. Some are known as
aggregate
functions. We will cover almost all of the aggreg-
ate and many numeric functions in this chapter. We won't cover the more advanced func-
tions related to statistics, or the mathematical functions related to calculus and geometry.
Instead, we will cover the most useful and most used functions and leave the others for you
to learn later on your own as you need them.
