Home » MariaDB Sum Function

MariaDB Sum Function

by Online Tutorials Library

MariaDB SUM Function

MariaDB SUM function is used to return the summed value of an expression.

Syntax:


SUM () Function with Single Expression

Example:

Calculate the total salary of the “Student” table where “student_id” is greater than 1.

Output:

MariaDB Sum function 1


SUM () Function with DISTINCT Clause

You can use DISTINCT clause with SUM function to avoid duplicate values summation.

Example:

Output:

MariaDB Sum function 2

You may also like