Skip
Arish's avatar

70. SUM Function


SUM Function

SUM adds up numeric values.

Syntax

sql
1SELECT SUM(column) FROM table;

Example: Total Age

sql
1SELECT SUM(age) FROM students;

Example: Total Marks

sql
1SELECT SUM(marks) FROM students;

With WHERE

sql
1SELECT SUM(marks) FROM students
2WHERE course = 'Python';