Trusted answers to developer questions
How to combine SUM() function with WHERE() clause in SQL
Maria ElijahOverview
In SQL, we use the SUM() function to add the numeric values in a column. It is an aggregate function in SQL.
The aggregate function is used in conjunction with the WHERE clause to extract more information from the data.
Syntax
The syntax for this is as follows:
SELECT SUM(column_name)
FROM table_name
WHERE condition;
Example
Let’s assume we have a table called Person with columns such as name, salary, state, and gender.
Now, we want to get the sum of the salary paid to people living in Lagos.
How do we extract this information from our table?
We use the following code to use the SUM() function with the WHERE clause in SQL.
CREATE TABLE Person (
ID int,
name varchar(100),
salary int,
gender varchar(10),
state varchar(15)
);
-- Insert data
INSERT INTO Person
VALUES (1,'Sharon Peller',40000,'Female','Kogi');
INSERT INTO Person
VALUES (2,'Paul Dons',150000,'Male','Lagos');
INSERT INTO Person
VALUES (3,'Ameera Abedayo',200000,'Female','Imo');
INSERT INTO Person
VALUES (4,'Maria Elijah',320000,'Female','Lagos');
INSERT INTO Person
VALUES (5,'David Hassan',250000,'Male','Abuja');
INSERT INTO Person
VALUES (6,'Niniola Disu',80000,'Female','Lagos');
INSERT INTO Person
VALUES (7,'Praise Dominion',340000,'Female','Lagos');
INSERT INTO Person
VALUES (7,'Divine Favour',280000,'Female','Abuja');
INSERT INTO Person
VALUES (7,'Praise Dominion',100000,'Female','Lagos');
INSERT INTO Person
VALUES (8,'Joe Smith',75000,'Lagos');
-- Query
SELECT SUM(salary)
FROM Person
WHERE state = 'Lagos';SQL SUM() function with WHERE clause
Explanation
In the code above:
- Line 1–7: We create a table called
Personwith columnsid,name,salary,gender,andstate. - Line 10–29: We insert data into the
Persontable. - Line 31–35: We find the sum of the salary paid to people living in
Lagosusing theSUM()function with theWHERE()clause.
RELATED TAGS
sql
postgresql
communitycreator
CONTRIBUTOR
Maria ElijahRELATED COURSES
View all Courses
Keep Exploring
Related Courses
