Aggregate and Numeric Functions - Learning MySQL and MariaDB - page 294

Summary
Although we didn't cover all of the aggregate and numeric functions, we covered most of
them — including the ones that are used most often. We primarily skipped the statistics
functions. We didn't cover many arithmetic functions, but those are prettystraightforward
(e.g., POWER(2, 8) returns 2 to the eighth power, or 256), or they're specialized(e.g.,
PI() returns π, or 3.141593). What's important is that you feel comfortable with aggreg-
ate functions and using the GROUP BY clause — you'll use them often — and that you
have a firm grasp on the numeric functions covered in this chapter. Several other numeric
functions exist, in case you ever need them. If you want to learn about these other func-
tions, you can check the MySQL documentation or the MariaDB documentation .