{"id":36519,"date":"2018-11-19T01:20:15","date_gmt":"2018-11-18T19:50:15","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=36519"},"modified":"2021-03-12T13:19:50","modified_gmt":"2021-03-12T07:49:50","slug":"sum-function-in-sql","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sum-function-in-sql\/","title":{"rendered":"SUM Function in SQL – Syntax and Cases With Examples"},"content":{"rendered":"

In this tutorial, we will understand in detail the SUM function in SQL. Let us now try to learn more about the Sum function with examples.<\/p>\n

What are the Aggregate Functions in SQL?<\/h3>\n

Aggregate functions are the built-in methods that help us to convert multiple values available in the column to a single entity.<\/p>\n

These are required to combine and draw insights from the data spread in columns of the database. Aggregate functions can also be applied to the expressions.<\/p>\n

Some of the most popular SQL aggregate functions are as follows:<\/p>\n\n\n\n\n\n\n\n\n\n
Sr.No<\/b><\/td>\nFunction<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
1<\/td>\nAVG()<\/td>\nReturns the average value.<\/span><\/td>\n<\/tr>\n
2<\/td>\nCOUNT()<\/td>\nReturns the count.<\/span><\/td>\n<\/tr>\n
3<\/td>\nMAX()<\/td>\nReturns the max out of given values.<\/span><\/td>\n<\/tr>\n
4<\/td>\nMIN()<\/td>\nReturns minimum out of the given values.<\/span><\/td>\n<\/tr>\n
5<\/td>\nSUM()<\/td>\nReturns the sum of the given values.<\/span><\/td>\n<\/tr>\n
6<\/td>\nVAR()<\/td>\nReturns variance of the given values.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Where do we use the SUM Function in SQL?<\/h3>\n

We use the Sum function wherever we need to find the total of an expression or a column.<\/p>\n

1. SUM(colName):<\/strong> Returns the sum of all values in the column colName.
\nSyntax:<\/p>\n

SELECT SUM(col1) AS alias,\r\n  Col2 , col3,.....\r\n  FROM tableName;\r\n\r\n<\/pre>\n
2. Sum(DISTINCT colName):<\/strong> Returns the sum of distinct non-null values in the column colName.
\nSyntax:<\/p>\n
SELECT SUM(DISTINCT col1) AS alias,\r\n  Col2 , col3,.....\r\n  FROM tableName;\r\n<\/pre>\n
Demo DataBase<\/h3>\n
Let us now view our demo database and understand it\u2019s contents.
\nQuery:\u00a0<\/strong><\/p>\n
SELECT * FROM DataFlair;\r\n<\/pre>\n
Output:<\/strong><\/p>\n
\"SQL<\/a><\/p>\n
In our DataFlair database, we have five columns indicating the details of all employees at DataFlair. The columns available are as follows:<\/p>\n