SQL Evi  
Tuesday, September 07, 2010
 
Aga Download, Aga Msn, Aga Oyun, Garavel, ASP Rehberi, ASP Indir, Bekir Topuz, Erinç Kuzu, Kartuş Marketi, SQL Evi - House
 
SQL Sum  
Home › SQL Sum  
The SQL SUM aggregate function allows selecting the total for a numeric column.  

The SQL SUM aggregate function allows selecting the total for a numeric column.

The SQL SUM syntax is displayed below:


SELECT SUM(Column1)
FROM Table1

We are going to use the Sales table to illustrate the use of SQL SUM clause:

Sales:

CustomerID Date SaleAmount
2 5/6/2004 $100.22
1 5/7/2004 $99.95
3 5/7/2004 $122.95
3 5/13/2004 $100.00
4 5/22/2004 $555.55

Consider the following SQL SUM statement:


SELECT SUM(SaleAmount)
FROM Sales

This SQL statement will return the sum of all SaleAmount fields and the result of it will be:

SaleAmount
$978.67

Of course you can specify search criteria using the SQL WHERE clause in your SQL SUM statement. If you want to select the total sales for customer with CustomerID = 3, you will use the following SQL SUM statement:


SELECT SUM(SaleAmount)
FROM Sales
WHERE CustomerID = 3

The result will be:

SaleAmount
$222.95

 
 
 
 
Home › SQL Sum Top  
 
Hosted By Speed Layer
© 2009 SQL Evi