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 Avg  
Home › SQL Avg  
The SQL AVG aggregate function selects the average value for certain table column.  

The SQL AVG aggregate function selects the average value for certain table column.

Have a look at the SQL AVG syntax:


SELECT AVG(Column1)
FROM Table1

If we want to find out what is the average SaleAmount in the Sales table, we will use the following SQL AVG statement:


SELECT AVG(SaleAmount) AS AvgSaleAmount
FROM Sales

which will result in the following dataset:

AvgSaleAmount
$195.73

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