Explain SUM function in SQL Server.

The SUM function is used to total sum of a numeric column.

Ex :

Select sum(EmployeesSalary) as TotalEmployeesSalary from Employees

This Query will display the sum of all the “EmployeesSalary” column fields, the output will be displayed with the column name “TotalEmployeesSalary”.