MariaDB Sum Function

MariaDB SUM Function

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

Syntax:

Example:

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

Output:

MariaDB Sum function 1

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

Example:

  SELECT SUM(DISTINCT salary) AS “Total Salary”  FROM Student  WHERE student_name = ‘Mahesh’;   

Output:

MariaDB Sum function 2