TheDeveloperBlog.com

Home | Contact Us

C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML

SQL SELECT SUM

SQL select sum function with sql, tutorial, examples, insert, update, delete, select, join, database, table, join

<< Back to SQL

SQL SELECT SUM

It is also known as SQL SUM() function. It is used in a SQL query to return summed value of an expression.

Let's see the Syntax for the select sum function:

SELECT SUM (expression)
FROM tables
WHERE conditions;

expression may be numeric field or formula.

This would produce the following result.

IDEMPLOYEE_NAMESALARY
1JACK REACHER32000
2PADMA MAHESHWARI22000
3JOE PETRA41000
4AMBUJ AGRAWAL21000

After using this SQL SELECT SUM example, it will produce the result containing the sum of the salary greater than 20000.

Total salary: 116,000


SQL SUM EXAMPLE with single field:

If you want to know how the combined total salary of all employee whose salary is above 20000 per month.

SELECT SUM (salary) AS "Total Salary"
FROM employees
WHERE salary > 20000;

In this example, you will find the expression as "Total Salary" when the result set is returned.


SQL SUM EXAMPLE with SQL DISTINCT:

You can also use SQL DISTINCT clause with SQL SUM function.

SELECT SUM (DISTINCT salary) AS "Total Salary"
FROM employees
WHERE salary > 20000;

SQL SUM EXAMPLE with SQL GROUP BY:

Sometimes there is a need to use the SQL GROUP BY statement with the SQL SUM function.

For example, we could also use the SQL SUM function to return the name of department and the total sales related to department.

SELECT department, SUM (sales) AS "Total Sales"
FROM order_details
GROUP BY department;

Let us take a table named order_details

IDDEPARTMENTDATEDAILY SALES
1Mechanical2012-08-13360
2Electrical2012-08-13100
2Electrical2012-08-14110
3Electronics2012-08-13150
3Electronics 2012-08-14170

After using the SQL GROUP BY statement with SUM, you will find the following result.

DEPARTMENTSUM(DAILY SALES)
Mechanical360
Electrical210
electronics320
Next TopicSQL SELECT NULL




Related Links:


Related Links

Adjectives Ado Ai Android Angular Antonyms Apache Articles Asp Autocad Automata Aws Azure Basic Binary Bitcoin Blockchain C Cassandra Change Coa Computer Control Cpp Create Creating C-Sharp Cyber Daa Data Dbms Deletion Devops Difference Discrete Es6 Ethical Examples Features Firebase Flutter Fs Git Go Hbase History Hive Hiveql How Html Idioms Insertion Installing Ios Java Joomla Js Kafka Kali Laravel Logical Machine Matlab Matrix Mongodb Mysql One Opencv Oracle Ordering Os Pandas Php Pig Pl Postgresql Powershell Prepositions Program Python React Ruby Scala Selecting Selenium Sentence Seo Sharepoint Software Spellings Spotting Spring Sql Sqlite Sqoop Svn Swift Synonyms Talend Testng Types Uml Unity Vbnet Verbal Webdriver What Wpf