‘Aggregate Functions’

SUM

For this example I use the AdventureWorks2008DW database  and I’m processing the query inside MS SQL Management Studio 2008. The SUM function in T-SQL returns the sum of the numeric values in a given column. The basic statement is SUM(“column name”). Inside the select statement it will look as follows: SELECT SUM(SalesAmount) FROM FactInternetSales Above query will give you… Read More