MariaDB SUM Function
In MariaDB, the SUM Function is used when we need to sum the values of an expression. The SUM() function in MariaDB is an Aggregate Function that calculates the sum of values in a specified column. The SUM Function takes a set of values and returns the sum, it ignores NULL values as the AVG() Function does.
Syntax:
SELECT SUM(expression)
FROM TABLE
WHERE [CONDITION];
MariaDB SUM() Function
MariaDB is an open-source database that comes under the Relational DataBase Management System(RDBMS). It was bought by Oracle in 2009. MariaDB is highly Compatible with MySQL. It offers exceptional performance and scalability which is optimized for the performance and efficient handling of large data volumes.
MariaDB can run on various Operating Systems like Windows, Linux, and MacOS. In this article, we will learn about the SUM Function in detail along with their examples, and perform various queries using various Functions Like GROUP BY, HAVING, and DISTINCT Clause.
Contact Us