How to find the sum of a column in SQL

Overview

The SUM() function is used to return the sum of the specified column that contains numeric values.

Syntax

SELECT SUM(column)
FROM table
WHERE condition;

School

ClassID

NumberOfStudents

1

25

2

20

3

15

CREATE DATABASE name;
CREATE TABLE School (
ClassID int,
NumberOfStudents int
);
INSERT INTO School
VALUES (1, 25);
INSERT INTO School
VALUES (2, 20);
INSERT INTO School
VALUES (3, 15);
SELECT *
FROM School;

Finding the sum of a column

SELECT SUM(NumberOfStudents)
FROM School;

This function finds the sum of the NumberOfStudents numeric column.

Free Resources