How to use sum function in SQL?

Question

Can anyone tell me how to use sum function in SQL?

Answer 1

SUM () function is an aggregate function that returns the sum of a set of values. The following is the syntax to use the SUM () function:

SELECT SUM (column_name)
FROM table_name
WHERE condition(s);

Here is the query to calculate the sum of salaries of employees whose location is ‘Bangalore’:

SELECT SUM (salary)

FROM Employee

WHERE location = ‘Bangalore’;

In order to learn SQL from top experts, you can register for this SQL training course by Intellipaat that provides instructor-led training, and also certification.